How to find out how many Rows are in a Database

[JordashTalon]

How would you detect how many rows are in a MySQL table which meet a certain criteria:

Pseudo Code:

$rowCount=How Many Rows in Table WHERE published='yes';

Thanks

[AnthonySterling]

<?php
$sSQL = "SELECT COUNT(id) AS numRows FROM table WHERE foo = 'bar'";
$rQuery = mysql_query($sSQL);
$aResult = mysql_fetch_assoc($rQuery);
printf(
    'The query "%s" resulted in %s rows.',
    $sSQL,
    $aResult['numRows']
);
?>

[JordashTalon]

thanks.