|
Home
iRate! IceMelon IM Tutorials Headlines CoolSites PHP Functions |
Most Referenced Functions » google_pagerank() » preg_replace() » imagecreatefrompng() » site_pageranks() » imagepng() » imagedestroy() » imagestring() » imagecolorallocate() » htmlentities() » fopen() » preg_match() » header() » getimagesize() » htmlspecialchars() » ob_start() » session_start() » strstr() » ob_flush() » preg_match_all() » strpos() » setcookie() » flush() » str_replace() » array2vars() » nl2br() » preg_split() » ereg() » urlencode() » ereg_replace() » readgzfile() Become a sponsor for $15/month. Link is sitewide - PR5 homepage, 20+ PR4 pages, 90+ PR3 pages. Email dave[AT]icemelon[D0T]c0m. |
PHP Functions
Function: mysql_num_rows (PHP 3, PHP 4, PHP 5) mysql_num_rows -- Get number of rows in resultDescriptionint mysql_num_rows ( resource result )Retrieves the number of rows from a result set. This command is only valid for SELECT statements. To retrieve the number of rows affected by a INSERT, UPDATE, or DELETE query, use mysql_affected_rows() . Parameters
result The result resource that is being evaluated. This result comes from a call to mysql_query() . Return ValuesThe number of rows in a result set on success, or FALSE on failure. Examples
Example 1. mysql_num_rows() example <?php $link = mysql_connect("localhost", "mysql_user", "mysql_password"); mysql_select_db("database", $link); $result = mysql_query("SELECT * FROM table1", $link); $num_rows = mysql_num_rows($result); echo "$num_rows Rows\n"; ?> NotesNote: If you use mysql_unbuffered_query() , mysql_num_rows() will not return the correct value until all the rows in the result set have been retrieved. Note: For downward compatibility, the following deprecated alias may be used: mysql_numrows() Related Function(s) |