My query:
SELECT *
FROM outlets
INNER JOIN users ON outlets.owner=users.id;
The result is an array in which the indexes from one table match those of another table. Is it possible to somehow make such a request that owner = array, and there is already a structure Result:
Array ( [id] => 1 [owner] => 1 [name] => Рома [email] => admin [username] => admin [password] => admin [role] => 1 [photo] => [permissions] => {"menu": {"menu.shop": 1, "menu.users": 1, "menu.stocks": 1, "menu.clients": 1, "menu.finances": 1, "menu.partners": 1, "menu.products": 1, "menu.purchase": 1, "menu.dashboard": 1}} [status] => 1 )
source https://stackoverflow.com/questions/73928683/mysql-join-promblem
No comments:
Post a Comment