How To Catch Results From Select Count(*)

[50r]

Hello freaks this has got me trying to figure out how to get the number of row using the select conunt() but i cant figure it out.

here is the code

$sql = mysql_query("SELECT COUNT(*) FROM tbl_menu WHERE module = $id");
if(!$sql){echo "there is an error".mysql_error();}

 

I just want to catch the number of row as a result.

[Pikachu2000]

You do it just like any other SELECT query, by using mysql_fetch_[array|assoc|row]() on the result resource.

[Psycho]

That query (assuming it doesn't fail) will return a singe record with a single element whcih is the number of rows that match your condition. So you just need to get the value from that first record. You can use the "normal" mysql_fetch function or you can use mysql_result()

 

$row_count = mysql_result($sql, 0);

 

$row = mysql_fetch_array($sql);
$row_count =$row[0];