mysql_num_rows.php : mysql_num_rows « MySQL Database « PHP


$query = "SELECT title FROM mytable WHERE myvalue > 15.99";
$result = mysql_query($query);
echo "There are ".mysql_num_rows($result)." product(s) priced above \$15.99.";

Related examples in the same category

1.Listing All Rows and Fields in a Table mysql_num_rows ( resource result )
3.Finding the Number of Rows Returned by a SELECT Statement with mysql_num_rows()
4.function mysql_num_rows() determines the number of rows returned from a SELECT query statement.