I was hoping someone could help me... I want ONE login page. The form would have a username box, a password box, and a list (student, staff, administration). If I were to sign in username:admin password:pswd and select administration, that would take me to the administration management area BUT it would not let me access the student management, for example, if I accidentally selected 'student'. Is this possible? OR is there a way to set the database up so it knows where to direct you? PLEASE, someone help me! I'll try to explain more clearly if I need to. THANKS.

You could certainly set up the database to automatically choose where the user goes after they log in. You could store a user type with the user and retrieve that when you check the login username and password. Then redirect according to the returned user type.

However, there is a more important issue to also consider: securing the other pages. Even though the login process directs the user to a particular page, they could still manually enter in a URL going to a different area and access it after they've logged in unless you protect against that. You'd need to save the user type so that you could check it at the beginning of each page. One simple way would be to use the session. Check the value of the user type and redirect to the login page (or an appropriate page for the current user type) when the user accesses a page that they aren't supposed to.

Peter
------------------------------------------------------
Work smarter, not harder.