i would like to display the number of comments to each particular article, but no matter how i set my SQL statement up, it always returns the same number for every article. as it is now, it is showing the total number of comments made.
i have two tables for this. news_comments and news_content. here\'s my SQL statement thus far:
$total_comments = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM news_content con, news_comments com WHERE com.news_id = con.id"),0);
i keep looking at it and it makes sense. there may be 100+ comments with the same news_comments.news_id value referencing a particular news.id value, but it always shows the total.
help please? i\'m somewhat \"new\" to this whole php/mysql thing. i followed quite a few tutorials to get to where i have this thing now. thanks in advance![/code]