Database integration.

Database integration connected at a user ID

[Alfasys]

Hallo,
since I'm a newbie concerning database integration I would like to ask you experts for advice :-)
I do have a database constructed out of two parameters : a UserID and a password. I do have a webpage with a login procedure and the UserID with correct password is verified in the database. When the combination is true, there is a protected page loaded. That all works just fine. BUT ... I would like to have a different page loaded for each user (so they can check certain private information) and I would like to put these people also in four big usergroups. Can you give me some advise please. Thank you.
Regards, Karl

[ergophobe]

Sure, you just need to add some columns to your database of user level (or type) for your four groups, and some preference columns, one of which could be "start page". You can also have their names in the DB and greet them.

Basically, when you get the password and userid out of the DB, you grab the other stuff too and use that to put content on the welcome/post-login page.

Sorry to be so vague, but I don't know at all what you're trying to do, with what software or anything.

One very common toolkit for this is PHP and MySQL. You might start by browsing the PHP forum library [webmasterworld.com]. It might just confuse you, but hopefully it will get you headed in the right direction.

[Alfasys]

Thank you for the quick respons.
I'm trying to set up a system for a RMA procedure were customers can check the status, but one may not see the status of the other. Our customers do also have to be grouped in four groups according the pricelist they may see for their group. I'm using an access database with a simple ODBC connection. The pages are programmed in ASP. All the help I can get is welcome. I will also check the PHP link. Thank you.
Best regards.
Karl