How to use mysql_num_rows in php

How to use mysql_num_rows in php?

Definition and usage

mysql_num_rows() function returns the number of rows in the result set.

Recommended: "PHP Tutorial"

Syntax

mysql_num_rows(data)

Parameters

data required. Result set. This result set is obtained from a call to mysql_query().

Description

mysql_num_rows() returns the number of rows in the result set. This command is only valid for SELECT statements. To get the number of rows affected by an INSERT, UPDATE, or DELETE query, use mysql_affected_rows().

Tips and Notes

Note: If you use mysql_unbuffered_query(), mysql_num_rows() cannot return the correct value until all rows in the result set have been fetched.

Example

<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
  {
  die(&#39;Could not connect: &#39; . mysql_error());
  }
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * FROM person";
$result = mysql_query($sql,$con);
echo mysql_num_rows($result);
mysql_close($con);
?>

Output similar to:

3

The above is the detailed content of How to use mysql_num_rows in php. For more information, please follow other related articles on the PHP Chinese website!