mysql_num_rows()

asgsoft · 03-04-2006, 01:27 PM

This is a mysql function that allows you to find out how many rows there are in a specific table.

It requires only one parameter which tells it whats the mysql query.

I found it extreemly useful when making a flash and mysql and php driven site.

PHP Code:

  <?php

$link = mysql_connect("localhost", "root", "");//conect to db server

mysql_select_db("haco", $link);//select db

 
$result = mysql_query("SELECT * FROM projects", $link); //select the table

$num_rows = mysql_num_rows($result); //set variable

 
echo "total_rows=$num_rows"; //echo number of rows

 
?>

i hope you find it just as useful to you just like when i first found it.

However if you are looking for executing queries fast I would use:

PHP Code:

  <?php

$link = mysql_connect("localhost", "root", "");//conect to db server

mysql_select_db("haco", $link);//select db

????: NamePros.com http://www.namepros.com/webmaster-tutorials/173485-mysql_num_rows.html
 
$result = mysql_query("SELECT COUNT(*) FROM projects", $link); //select the table

????: NamePros.com http://www.namepros.com/showthread.php?t=173485
 
echo "total_rows=$result"; //echo number of rows

 
?>

That was a suggestion by NuPagady

NuPagady · 03-04-2006, 01:45 PM

Yes, that would work. However, I think "SELECT COUNT(*) FROM projects" query would work faster.

asgsoft · 03-04-2006, 01:46 PM

thanks for the suggestion. I will add it too.

J4m!3 · 03-06-2006, 03:46 AM

Got to agree

JuggernautH · 03-06-2006, 04:13 AM

Thnx for the helpfull information, i used to code php and that stuff before, but i havent done so in about 1.5 years

03-04-2006, 01:27 PM	THREAD STARTER #1 (permalink)
asgsoft NamePros Regular Join Date: Sep 2005 Location: At Home Posts: 881	mysql_num_rows() This is a mysql function that allows you to find out how many rows there are in a specific table. It requires only one parameter which tells it whats the mysql query. I found it extreemly useful when making a flash and mysql and php driven site. PHP Code: `<?php $link = mysql_connect("localhost", "root", "");//conect to db server mysql_select_db("haco", $link);//select db $result = mysql_query("SELECT * FROM projects", $link); //select the table $num_rows = mysql_num_rows($result); //set variable echo "total_rows=$num_rows"; //echo number of rows ?>` i hope you find it just as useful to you just like when i first found it. However if you are looking for executing queries fast I would use: PHP Code: `<?php $link = mysql_connect("localhost", "root", "");//conect to db server mysql_select_db("haco", $link);//select db ????: NamePros.com http://www.namepros.com/webmaster-tutorials/173485-mysql_num_rows.html $result = mysql_query("SELECT COUNT() FROM projects", $link); //select the table ????: NamePros.com http://www.namepros.com/showthread.php?t=173485 echo "total_rows=$result"; //echo number of rows ?>` That was a suggestion by NuPagady __________________ Free SEO and Domain tools* \|HTML ENT\| Your Source to expired domains with PageRank & tips Last edited by asgsoft; 03-04-2006 at 01:48 PM. Reason: adding an extra suggestion by NuPagady

03-04-2006, 01:46 PM	THREAD STARTER #3 (permalink)
asgsoft NamePros Regular Join Date: Sep 2005 Location: At Home Posts: 881	thanks for the suggestion. I will add it too. __________________ Free SEO and Domain tools \|HTML ENT\| Your Source to expired domains with PageRank & tips

03-06-2006, 03:46 AM	#4 (permalink)
J4m!3 NamePros Member Join Date: Oct 2005 Location: Clevedon, UK Posts: 198	Got to agree __________________ - Submit Gas Price related Pix & Rants @ PumpPanic.com -

03-04-2006, 01:45 PM	#2 (permalink)
NuPagady NamePros Regular Join Date: Jul 2005 Posts: 483	Yes, that would work. However, I think "SELECT COUNT(*) FROM projects" query would work faster.

03-06-2006, 04:13 AM	#5 (permalink)
JuggernautH Account Suspended Join Date: Dec 2005 Location: ../home/mysite Posts: 3,565	Thnx for the helpfull information, i used to code php and that stuff before, but i havent done so in about 1.5 years

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)