Return number of rows in table

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 402,525 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,487 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

Thread Tools Display Modes

Views: 2812 | Replies: 4

•

Join Date: Mar 2007

Location: georgia

Posts: 55

Reputation: hunkychop is an unknown quantity at this point

Rep Power: 2

Solved Threads: 4

hunkychop

Offline

Junior Poster in Training

Return number of rows in table

Apr 21st, 2007

does anybody know a mysql query that i can use in my php document that will return the number of rows their are in a table?

thanks, i cant find it in the MySQL mannual

Last edited by hunkychop : Apr 21st, 2007 at 11:45 am.

•

Join Date: May 2006

Location: New Jersey

Posts: 1,422

Reputation: stymiee is on a distinguished road

Rep Power: 5

Solved Threads: 34

stymiee

Offline

He's No Good To Me Dead

Re: Return number of rows in table

Apr 22nd, 2007

mysql_num_rows()

John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!

•

Join Date: Mar 2007

Location: georgia

Posts: 55

Reputation: hunkychop is an unknown quantity at this point

Rep Power: 2

Solved Threads: 4

hunkychop

Offline

Junior Poster in Training

Re: Return number of rows in table

Apr 22nd, 2007

how whould i use that to return the result in php. do i just use

•

$result = mysql_num_rows(info);

or is there more to it

•

Join Date: May 2006

Location: New Jersey

Posts: 1,422

Reputation: stymiee is on a distinguished road

Rep Power: 5

Solved Threads: 34

stymiee

Offline

He's No Good To Me Dead

Re: Return number of rows in table

Apr 22nd, 2007

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
 
$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);
 
$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
 
echo "$num_rows Rows";
 
?> 
<?php

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

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows";

?> 

Last edited by stymiee : Apr 22nd, 2007 at 9:27 pm.

John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!

•

Join Date: Aug 2006

Location: NE PA

Posts: 8

Reputation: dc dalton is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

dc dalton

Offline

Newbie Poster

Re: Return number of rows in table

May 2nd, 2007

Actually, not to step on Stymiee's feet but there is a a less memory intensive way to do it.

SELECT COUNT(*) FROM table_name

The result will be the num rows

david c. dalton - web application & database development .
Article Site Management Software
How to Choose A Web Developer