user db.

[hopopolous]

how would i make a user db, so that certain users can login to the acp, and some could login to post? 🙂 please actaully show the code, because i am fairly new.

[TTT]

if you got tables: users, user_rights, tasks

SELECT t.name as name
t.id as id
FROM tasks t INNER JOIN user_rights ur ON t.id = ur.user_id
INNER JOIN users u ON ur.user_id = u.id
WHERE u.id = $currentUserId
ORDER BY t.id ASC