[SOLVED] 2 tables

[onthespot]

Ok so i have a news table and a news comment table.

Inside the news comment table, i have made the newsid a foreign key, which was a primary key in the news table.

 

Im unsure about how to linked the two on a page and therefore that will display the comments at the bottom of each news page in php.

 

I should be ok once i understand how to get the two tables working together.

 

Would be helpful if someone could guide me.

[p2grace]

Two ways:

 

Method 1:

SELECT * FROM `news` `n`, `news_comments` `c` WHERE `n`.`newsID` = `c`.`newsID`

 

Method 2:

SELECT *
FROM `news` AS `n`
INNER JOIN `news_comments` AS `c` USING ( `newsID` )

[rhodesa]

When displaying a news item, you should know the id of it. Then, just select the comments for it:

SELECT * FROM news_comments WHERE newsid = '$newsid'

[onthespot]

cheers for the replies, rhodes that really makes sense.