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

Advertisements

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?

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 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