Re: How to show data from db

When you add/create a user you should generate some unique numerical ID for this user. Then in another table where you store all the data, the Primary Key for this data is that unique ID. So you do a select from the users table to get the ID then a select from the data table with that ID and you have all your data for that user. Is that what you mean? That is fairly generic and simple to implement. /Cody Caughlan Emir Musabasic wrote: > > Hi guys, > > I posted a little earlier on php-general but then realized that posting > here would maybe be better as my question got a lot to do with db stuff. > So here it's > I've stumbled into a problem that I can't figure out how to solve, > basically what I want to do is to have a user log in and when a user logs > in using his login name and password that I have stored in a mysql table > called users, then I want to show him the data that he has submitted before > and that is stored in a mysql database and give him the ability to change > that data, so if I for example have a directory I want the users listed in > it to be able to change for example the description of their site and so > on. Can anybody help me with this or if somebody has the code to do > something like this send it to me. I would be really grateful for all the > help, I sure need it. I've tried to find something about this in the manual > but I really don't know what I need to do so that I can pull this off, > kinda hard to find it then. :)))))) > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- -------------------------- Cody Caughlan codyc@cats.ucsc.edu