Sending logins to their own page

[jerrodd]

Hello, I am constructing a login page that will send clients to "their own page" that pulls in info from my databases on website creation jobs that have been charged a fee, but not paid.

1. I use the DreamWeaver MX login behavior. How do I modify it to browse a table to send the login person to the proper page? Also, can the report/filter page of their info be created on the fly?

2. I'm using the relational database system that links the Sales info to the Client info. How would I only show the Jobs that have been charged and not paid?

I am new with this, but I just need a starting point, and I will be off and running. If there is a thread that deals with this, or tutorials, that's be great. Thanks, Jerrodd.

[snoopy13]

hy
1. it might not be enough to use the dreamweaverMX login page - why don't you make a whole new script?
you make a page: login.php where you ask the user to enter user name and password. then you open the database and check if name and password are correct. if yes you can dynamicly create a page with the information stored in the database for each user. or did I missunderstand your question?

2. if you use 2 tables you need a join:
   example: SELECT * FROM sales, client WHERE sales.client_ID=client.client_ID AND sales.paid!='paid'

ok?