How can we find the number of rows in a result set using PHP?

How can we find the number of rows in a result set using PHP?

How can we find the number of rows in a result set using PHP?

View Answers

November 15, 2010 at 6:18 PM

Hi everyone,

If you want to find out the number of rows in the result set then use mysqlnumrows($resultsetname) function.

Syntax :

$no_of_rows=mysql_num_rows($result_set_name);
echo $no_of_rows;

Thanks









Related Tutorials/Questions & Answers:
How can we find the number of rows in a result set using PHP?
How many ways we can retrieve the date in result set of mysql using php?
Advertisements
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
How many ways we can retrieve the date in result set of mysql using php?
Write a query to find the total number of rows in a table
How can we know the number of days between two given dates using PHP?
Php Sql num rows
find factorial of any number using recursion
How can we solve this puzzle using java ?
How can we know the count/number of elements of an array?
How to add a columns with a button set to a Jtable built with database result set
What is the difference between PHP4 and PHP5?
Php Sql num rows
how to chech result set is null or not - Java Beginners
ModuleNotFoundError: No module named 'phpy'
PHP SQL Number of Rows
Result=Set - Java Beginners
how to store the REsult Set values in array and loop through it in java?
how to store the REsult Set values in array and loop through it in java?
Find Records of The Rows Using POI
Rows Count Example Using JDBC ResultSet
Program to Find Cube Root of any Number without using built in function
how to find largest number? - Java Interview Questions
Getting Number of Rows
How can we encrypt the username and password using PHP?
How can we create a database using PHP and mysql?
Sort Result set
How can we get second of the current time using date function?
JDBC: Rows Count Example
how to find square and cube of five number
how can i display a editable result of form?
Java get number of rows in resultset
Count Rows from a Database Table
Getting the Number of Rows and Columns in JTable
How to set Messages number to be read in pop3 mail server
How to set Messages number to be read in pop3 mail server
How we can integrate ASP .net website to payment gateway using SOAP xml request and response using wsdl.
What is the maximum size of a file that can be uploaded using PHP and how can we change this?
Hibernate Narrowing Criteria Result Set
How do I find out the number of parameters passed into function9. ?
Find out the prime number
How to sort the rows in SQL?
Result Set one to many mapping
Php Sql Number of Rows
how to Insert Array Values Into Separate Rows using java?
Find Twin Primes Number using Java

Ads