Creating a user list from a database

[sdm]

I really hope someone here can give me some direction.

This is what i'm trying to achieve.

I've created a message system where messages can be left for a customer, they can then log in and check their messages, as well as do admin, changing the status, deleting them etc.

Here's where i'm getting stuck now, i've got a company interested in the system but so far it's a single system and they want to be able to add other users to it. Would you recommend I create a table for each user to store their messages in.

What I need is to create a front end that lists customers with a link to their folder, cust1, cust2 etc. Can I store their location in the database, e.g. /cust1/admin ? and have it appear as a link ?

Is there any tutorials or pointers anyone can give about how to go about trying to do this, with url's if possible.

Thanks for your time.

SDM

[bastien]

You've got a ton of questions in here, the short answer is YES you can do with php and a database.

As for creating a new table for each user, NO. It violates the basis of good DB design (as the info is all the same, only the names will change)

Creating the links are easy as pie. The best way is to store folder name in the DB, and when echoing it out just toss that vairable into the link

ex.

//field name is 'folder'
$folder=$rows['folder'];

echo "<a href=\"www.mysite.com/details.php?$folder\">Click here to access $folder details</a>";

You can look at SourceForge. they may have something similar or try google

EDIT
The trick to remember is that you are not designing for a particular user, but for an activity that the users want.

hth