How to create a user type that directs its designated page?

Hi,

Since you have not provided enough information, I am only assuming things here and providing what can be done.
I assume that;

1. In your database, you have a lookup table "UserTypes"
2. In your database, you have a users table with "UserTypeID" as a foreign key linked to the table in point No. 1 (UserTypes)
3. Upon successful login, user should be redirected to a specific page based on the type of the user

OK, here is what I would do;

1. I will add a column named "DefaultRedirectURL" to UserType table i.e. Each user type will have its own redirecURL
2. Have a single login page which validates the user name and password with the login database table
3. Upon successful login, I query the database for user information based on the login ID/name/code (whatever you use). This query will return me defaultRedirectURL along with all other information
4. I will grab that defaultRedirectURL and redirect the page accordingly.

I hope this resolves any issues.

Ask if you have any further questions.

Anyone else thinks this can be done in a better way, please suggest so that I can also improve my strategies - after all we are all coders.

Cheers