Storing Comments in MYSQL

[imperium2335]

Hi, what is the best way to store comments in a Mysql database?

 

I have image pages each with a unique ID number in the database, my first idea is to create a new column and have every comment for a given image stored in that field and separated by a symbol combination. This seems crude, is there a better way? I would also like to store the users name and the date they left the comment.

 

Thanks in advance.

[RussellReal]

no..

 

make a comments table, and have the following fields

 

comment_id | image_id | user_id | comment

[xtopolis]

Read this

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

 

And use a one to many relationship  [1 picture -< many comments]

[imperium2335]

So how would I relate each comment to what image_id? Each image will have more than one comment.

[RussellReal]

yes..

$id = (int) $_GET['id'];

mysql_query("SELECT users.username, comments.comment FROM comments JOIN users ON (comments.user_id = users.id) WHERE image_id = '{$id}'");