[RESOLVED] MySQL count() statement

spiritssight

Hello All,

I am wondering how to get the count() statement to show the number of records in the table, I don't want to know how many ... but just need to know the number of records, below is the code I am using so far:

<?php

ini_set('display_errors', 'ON');
ini_set('error_reporting', E_ALL | E_STRICT );

include '/home/dev/www/includes/db_config_cr-dev.php';
include '/home/dev/www/includes/db_conn-select.php';

$query_s = "SELECT COUNT(EIN) FROM irs_rawdata";
$result_s = mysql_query($query_s) OR die("Sorry, unable to count the records in the table!");

echo " There are ".$result_s['EIN']." in the table!"

?>

the code above appears to work but does not show the results.

So what am I doing wrong?

Sincerely,
Christopher

PS: I am still looking on the net for the answer while I wait for someone to respone :-)

laserlight

I am wondering how to get the count() statement to show the number of records in the table, I don't want to know how many ... but just need to know the number of records

That sounds like a contradiction: isn't how many records the number of records?

That said, perhaps you are looking for:

$query_s = "SELECT COUNT(*) FROM irs_rawdata";
$result_s = mysql_query($query_s) OR die("Sorry, unable to count the records in the table!");

echo " There are " . mysql_result($result_s, 0) . " in the table!";

spiritssight

I was just going to make a change to the code and post it as you did the post :-)

That what I wanted :-)

could you explain to me:

mysql_result($result_s, 0)
I know the mysql_result() thing but what is the 0 mean, is this the first record of the results if so then I guess i do understand

thanks again!
Christopher

laserlight

The 0 indicates that we want the first row. Since the column is not specified, we get the first column. It so happens that the query returns one row and one column, so this function is appropriate.

spiritssight

Thanks a lot!

thats a good way to remember the function also :-)

Sincerely,
Christopher