inserting MULTIPLE data in mysql
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
|