Foreign key?

[GuTe]

hi all

i've got a site with articles on it that are stored in a mySQL db. Now I would like to build a comment section for every article so that you can discuss the article.
How can I make this comment section so that the comments end up with the right article?

Somebody told that I should take the articles ID and use a foregin key, but I have no idea how to make that real 🙂

Im using PHP 4.3. and mySQL 3.23.49

[LarsLai]

hi!
"real" foreign keys you cannot use with mysql 3.23.49, i think.
in newer version their is a table type called "innodb" which can master this.

so what you can do is the following:

you have your article table, eg:
article_id | article_name

then you have your comment table, e.g.
comment_id | comment | article_id

then your article_id in the comment table is a foreign key.
to make sure you set the right article_id to your comments
their is no way but coding it by yourself.

[GuTe]

Cheers mate, i'll try it 🙂