inserting MULTIPLE data in mysql

[alco19357]

Hey. I need a comments system for my members of my site. It looks like myspaec, and it logs into a database (MySQL) via localhost. I want it to store multiple data about the user. So that other users can leave feedback. It's kinda of like a forum, I believe. So say user X writes about user A. Then say user Y writes about user A. I want it to write on the view profile page, of user A: the comments left by user X, and user Y.

How do I store this in a mysql base. I have a database assigned to the whole project. Table 1 = admin, Table 2= users. In users table i have all the user data, like pics, name, pass, email, about me, and etc. Im not sure if I should also add the comments in the user table (table 2). Please help.

THanks, alex

[crebilis]

Hi,

you could make a second table called comments. As the name suggests, you store all the comments inthere, like you would do for a forum thread. The columns could be like: id, poster (user Y or X in your example), user (user A), comment, date (if you want to store the date on which teh comment was added).

I hope this helped,

Crebilis

[alco19357]

I dont get it. If I just used the same thing, wouldnt that erase the old data, and over write when someone new replies?

[Xnuiem]

Just insert new records each time.

[crebilis]

yup, each time a new record in the databse.

on the profile page of user A, you just take out all record where the user is A and write them down through a while loop.

It's just like you would do a forum thread, so if you need examples, there are enough basic forum scripts on the internet, so take a look at those codes.

and don't forget:

www.mysql.com
www.php.net
www.google.com

are your friends .

Crebilis