mysql_num_rows.php : mysql_num_rows « MySQL Database « PHP

  1. PHP
  2. MySQL Database
  3. mysql_num_rows




mysql_num_rows.php

 
<?
mysql_connect("localhost","root","");
mysql_select_db("mydatabase");
$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
2.int 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.