Russian Ukraine English
Catalog RSS


(PHP 3, PHP 4 )

mysql_num_rows -- Get number of rows in result


int mysql_num_rows (int result)

mysql_num_rows() returns the number of rows in a result set. This command is only valid for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE, use mysql_affected_rows().

Example 1. mysql_num_rows example by ()

<?php $conn = mysql_connect("hostaddress", "username", "password");  mysql_select_db("database",$conn); // needed if you have m,ultiple db's $Resultfornummembers = mysql_query("SELECT * FROM Accounts",$conn);  $NumMembers = mysql_num_rows($Resultfornummembers);  echo "$NumMembers Members"; ?>                                 

See also: mysql_db_query(), mysql_query() and, mysql_fetch_row().

For downward compatibility mysql_numrows() can also be used.