(PHP 3, PHP 4 )
mysql_num_rows -- Get number of rows in result
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.