Help please :(

[mr.confused]

Hey there, basically I need help to separate the users from the staff in my items table i can do this by the user_id field in the items table.

but in the items table there is no way of telling which user_id is a staff member. Only way to find out is in the users table by the rank field

 

is there any way i would be able to do this?

[Mahngiel]

add a groups table with columns that delineate a group id and a group name. then associate each user with their respective group / rank.

[jcbones]

You will need to join the items table to the users table to limit the query based on the rank. 

 

example

SELECT i.* FROM items AS i JOIN users AS u ON i.user_id = u.id WHERE u.rank = 'staff';

 

MySQL JOIN Syntax