I've built a page that I use to allow admins on my site to give normal users to the site administrative privileges. I've set up two tables one is called 'user' and contains info of all users on the site (including admins), the other is admin, this contains only the name of all users who are admins and is used to determine admin status. Upon signing in a session is registered for either a user, or admin depending on if the users name can be found in the admin table. I use this session to display the user or admin's name.
This all works great, but when I add a normal user to the admin table from my add admin page, and access the session containing the current admin's display name, I find the session 'admin' is still registered but for some reason it no longer contains the admin's name and displays nothing where the username should have been.😕
I'm completely stumped, I can't quite figure out what is going wrong here. Any help would be greatly appriciated, thanks
