i have a database structure like this
and am trying to print the rows count but am getting 1 only
the code am using is
$sql="select Count(*) from uniqueviews where hour=13"; $result=mysql_query($sql); $ml=mysql_num_rows($result); echo $ml;
according to the query it should print 6 but its printing 1
where am doing wrong ?
i think its counting the rows ?
how can i print the result after rows count ?