Page 1 of 1

Need some help with MySQL count query and php display

Posted: Mon May 11, 2009 8:33 am
by yonik
Try:

Code: Select all

$query = "SELECT count(*) AS num FROM entries";
$results = @ mysql_query ($query, $connection);
$row = mysql_fetch_assoc($results);
echo $row['num'];