Sessions required for Admin privs and DB Updates?

[kilbey1]

I have a MySQL database table with an enum field "Admin" y/n. I'd like to use this to show content based on if they have admin status (y) or not.

First, obviously I'd call up if admin status = y from the database. But each user has his/her own login name and password, so would this require the use of sessions as well? Or is it really uneccessary after the user is logged in? ie. simple matter of if $username has $admin y, then show X, else Y.

Second part to this is, are sessions also required if I want to track who makes changes to the database (ie. by entering username into a 'last updated' field)?

[nunomira]

hi,

I answer "yes" to both your questions.

As you'll probably want to check in each page whether a user can view it or not, sessions are a nice way to store the variable that answers that.

In the same way, sessions can be used to keep/store the user's username, and insert it in the DB when she updates or inserts data.