如何在表之间建立关系？

Question

I have one table for posting new articles and the content of the table is printed using a while loop.

Now I want the viewers to be able to comment on the article so I created another table for comments and a form under article in the while loop, but whenever anybody comments on the article the comment is showed with all the articles.

Because article and comments are in one while loop and there is no relationship between the tables. tables are as follows:

content_posts( id int primary auto, subject varchar, postby varchar, date date, content varchar )

comments( id int primary auto, name varchar, email varchar, body varchar )

Answer 1

You can try linking the tabels by the aticle id column: for example: ARTICLES with the column id and COMMENTS with a field named article_id which will contain the id of the corresponding article. Then you can use an INNER JOIN like this

SELECT * FROM ARTICLES as t1 INNER JOIN COMMENTS as t2 ON t1.id = t2.article_id

Hope it helps!