login to different pages based on access

[allprographics]

I am a graphic designer who has been given the task of creating our website (already up). I need to create a login page for our top clients that will direct them to their own pages. I am using Dreamweaver and have a MySql database on the host. example:

user: joe
PW: xxxx
company: xyz

Direct to xyz page

user: sue
PW: xxxx
company: abc

Direct to abc page

I've looked but haven't found anything that is directly related to this. Can anyone point me in the right direction? Any help would be greatly appreciated. Thanks in advance

[sneakyimp]

You need to:

1) create a login form
2) create a script to handle the login form
- should validate input
- should take username/login and check db
- should redirect user to appropriate page if login successful

what parts are you having trouble with? It would be helpful to start with some code that you've tried.