[RESOLVED] Question on Mysql count.

[KiwiDexter]

Anyone know if there's a better approach than doing

$query = "SELECT COUNT(name) FROM members"; 
	 
$result = mysql_query($query) or die(mysql_error());

simply want a count of the rows really and don't need anything returned.

oh oh oh ... is it possible to do a sort of "COUNT" "WHERE" thing to only count records matching a criteria?

[penagate]

(1) The return value of that query is the row count, which is what you want...

(2) select count(*) from members where a=b

[kows]

you can use the mysql_num_rows() function to see how many rows resulted from your query, though you can use MySQL's COUNT() function to do add a WHERE clause, too. If you're only looking to return the number of rows (and not any actual data from the query), COUNT() might be faster.

<?php
  $sql = mysql_query("SELECT id FROM table WHERE this='that' AND that='this'");
  $num = mysql_num_rows($sql);
  echo "There were {$num} rows returned.";
?>

[KiwiDexter]

Thanks dude that works just like a brought one