Echoing Number of Values in MySQL Table - Webmaster Forum - Web Design, Programming and SEO forums

07-10-2008, 10:48 AM

Seb

Status: Watermelon Man
Join date: Nov 2006
Location: London
Expertise:
Software:

Posts: 3,312

iTrader: 36 / 100%

Seb is on a distinguished road

Echoing Number of Values in MySQL Table

I'm useless at PHP, but could anyone tell me how to echo the number of fields in a MySQL table?

Eg. I have 1800 entries in the table, I want to be able to echo the value "1800".

I'd be very grateful

Sorry if this is vague, but let me know any questions.

07-10-2008, 11:42 AM

aboyd

Status: Junior Member
Join date: Jan 2006
Location: USA
Expertise:
Software:

Posts: 38

iTrader: 0 / 0%

aboyd is on a distinguished road

$query = 'SELECT count(*) FROM tablename';
$result = mysql_query($query);
list($tally) = mysql_fetch_row($result);
echo $tally;

07-10-2008, 12:26 PM

Seb

Status: Watermelon Man
Join date: Nov 2006
Location: London
Expertise:
Software:

Posts: 3,312

iTrader: 36 / 100%

Seb is on a distinguished road

Originally Posted by aboyd

$query = 'SELECT count(*) FROM tablename';
$result = mysql_query($query);
list($tally) = mysql_fetch_row($result);
echo $tally;

Thanks, works like a dream

- http://www.codedpreview.com

07-10-2008, 06:43 PM

Immersion

Status: Senior Member
Join date: Dec 2005
Location:
Expertise:
Software:

Posts: 918

iTrader: 5 / 100%

Immersion is on a distinguished road

You probably dont need to count * (wildcard) It would probably be faster if you just select one column such as ID which will be indexed. This should decrease the load and make it faster to execute. Just a thought.