[RESOLVED] trying to count

[jerrylouise]

$result = mysql_query("SELECT `new` FROM `privatemail` WHERE `to` = '$id'");
$num_rows = mysql_num_rows($result

I have the following querry that works, but it dosn't do what i want, what i want is for it to only count the rows where table:new = "new!" form tableprivatemail where tableto = the userid ('$id')

[paulnaj]

Hi,

If I understand you correctly ...

<?php
$result = mysql_query("
SELECT *
FROM `privatemail`
WHERE `to` = '".$id."'
AND `new` = 'new!' 
");
$num_rows = mysql_num_rows($result);
?>

... or ...

<?php
$result = mysql_query("
SELECT COUNT(*)
FROM `privatemail`
WHERE `to` = '".$id."'
AND `new` = 'new!' 
");
$num_rows = mysql_result($result, 0, 0);
?>

P.