COUNT mysql ?

[iBuddy_Media]

I'm trying to have a command count the total of entries that are in a database. What is the command?

    <?
$result = mysql_query("SELECT Count('id') AS nTotal FROM news ORDER BY id DESC",$db); 
while ($myrow = mysql_fetch_row($result)) { 


echo "$nTotal"; 

}
?>

This is not working can someone help me with the coding?

[barand]

You can't order by id unless you select id. But as you want the count you need to group by

$result = mysql_query("SELECT id, Count('id') AS nTotal FROM news GROUP BY id ORDER BY id DESC",$db);

while (list($id, $nTotal = mysql_fetch_row($result)) { 


echo "$id  :  $nTotal<br>"; 

}

hth

[kevinsequeira]

$result = mysql_query("SELECT Count(*) FROM news",$db);

while ($myrow = mysql_fetch_row($result)) {
echo $myrow[0];
}

reg
kevin

[iBuddy_Media]

Kevin just wanted to let you know that this worked perfectly! Thanks a lot!😃