PHP: how do you get the number of rows returned by a query?

hello-world · #1 (**permalink**) 02-11-12, 22:58

I want to know how many rows are in a result. I know you can use mysql_fetch_array iteratively, but can you get the size directly?

healdem · #2 (**permalink**) 02-12-12, 03:31

try boning up on the PHP manual
especially
PHP: Mysql - Manual

sonic10 · #3 (**permalink**) 02-12-12, 10:22

Here is a very basic way.

PHP Code:


			
<?php



$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("database", $link);



$result = mysql_query("SELECT * FROM tbl1", $link);

$num_rows = mysql_num_rows($result);



echo "$num_rows Rows\n";



?>

Internet Services

Web Development

Digital Marketing

Consumer Tech