This query is killing me

[Baseball]

	$sql2 = "SELECT COUNT(*) as num_replies
FROM forum_replies
LEFT JOIN forum_topics ON ( forum_replies.tid = forum_topics.id ) WHERE `cid`='".$row['id']."'
                      ORDER BY lastposttime DESC";

 

Ok everything works but it's only spitting out the number replies... which it says it's 83, which means it's counting it from all together but i need to count for each WHERE Claus... and collect all the data.. Help ?

 

in other words i need to count(*) as num_replies to display for each time WHERE `cid` = is at

[gerkintrigg]

So you want:

SELECT *, COUNT(*) as num_replies FROM forum_replies
LEFT JOIN forum_topics ON ( forum_replies.tid = forum_topics.id ) WHERE `cid`='".$row['id']."'
                      ORDER BY lastposttime DESC";

etc?

[ignace]

SELECT *, COUNT(*) as num_replies FROM forum_replies
LEFT JOIN forum_topics ON ( forum_replies.tid = forum_topics.id ) WHERE `cid`= $id
                      ORDER BY lastposttime DESC
GROUP BY columnOnWhichYouWantToGroupAndThusCountForWillBeUsed