Description
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 crubel@trilizio.org ()
<?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.