SQL COUNT(condition)?
 

<div>Hi,

I have two queries:
Code:
SELECT COUNT(*) AS comments
FROM ng_comment
WHERE ng_comment.collectionid = 47

<div class="bbcode_container"> Code:
SELECT COUNT(*) AS comments2
FROM ng_comment
WHERE ng_comment.collectionid = 47
AND ng_comment.dateline