How to display comments under each post

[Stefany93]

Hello colleagues,

 

Please help me! Here is the issue:

 

I have two tables in the Mysql DB one called posts and its columns are

 

id title contents category_id datetime

 

And I have another table whose name is comments and its fields are:

 

id name comment

 

So far I managed to display the comments from the databse, but the problem is that I want to display comments only that correspond to a specific post from the DB. Please, please help me, I have been trying to figure it out for weeks and still can't find the answer!

 

Thank you!

 

Best Regards

Stefany

[Bottyz]

you could add an additional field to the comments table such as postid and have it store which post number the comment belongs to?

[Stefany93]

Thank you, but is there any way I could increment this post_id automatically?

[xyph]

Google up AUTO_INCREMENT

[Stefany93]

I tried AUTO_INCREMENT in the phpmyadmin but an errors occures telling me that only the primary key can auto - increment... Please tell me what to do?

[mikosiko]

you are doing that wrong then.

 

the suggested post_id field in your table comments must reference the column id in your table posts, if that field IS an AUTO-INCREMENT field you don't need to declare it again in the table comments

[Drummin]

The table you had was probably fine for the comment table with for example id as the AUTO-INCREMENT field.  You'll want to have that id field to identify the comment for updates etc.  You just need to add the post_id field as noted and add this id when comment is added.