displaying number of entries
Posted: Sun Mar 25, 2012 10:31 am
Hi please, I am finding it difficult to display total number of vendors in my database. The code used are:
Code: Select all
<?php
require_once ('dbc.php');
$q = "SELECT count(id) as count FROM users";
$r = @mysqli_query ($dbc, $q);
$row = @mysql_fetch_array($r, MYSQLI_NUM);
?>
<font face="Tahoma" size="2" >Vendors online: <?php echo $row['count']; ?></font>