I have a mysql database (innoDb) with two tables. The first table is called Admin and contains the following columns.
id (autoincrementing), AdminName and AdminPwd.
The second table is called Users and contains columns id(autoincrementing), UserName, UserPwd and id_Admin (foreign key)
I want to be able to create several administrators who can then create their own list of users, and that list is completely unrelated to other lists of users.
I would appreciate some help. I can display the users in a table, but all users are displayed at the same time. I can log on as any one of the administrators to select users, but am unable to display the group belonging only to the logged in administrator.
Thanks in advance.