State Article with it's Comments

[vividona]

I have 2 tables one for articles and the other for comments

how can I fetch the comments of each article

now when I made fectching all comments show in the first article

I need to state every article with it's comments

Plz help me with a code example if any

[igorlopez]

I am now making some assumptions with respect to your table layout:
Articles:
- articleId
- articleContent

Comments:
- commentId
- commentContent
- articleId

Which means that each comment only can point to one article but you can have many comments to one article.

To get the comments for a specific article from Article with articleId equal thisArticle you need to:

SELECT commentContent FROM Comments WHERE articleId=thisArticle;

Above statement is SQL syntax which you just need to adapt to your choice of DB abstratction layer.

[vividona]

Oooh I got the trick

there must be 2 unique key for any table

thax so much I am trying now

[laserlight]

there must be 2 unique key for any table

Not really. In the Comments table, articleId is a foreign key to the Articles table, and it may contain duplicate values since an article might have more than one comment. commentId, on the other hand, should be unique as it acts as the primary key for the Comments table.

[vividona]

hi friends,

everything is ok
my funny script works very good specially comments.

thx again and again