Major stress with a simple count(*) function

[tanle]

Hi, i am trying to count the number of books in my database, the codes are:

//connect to the database and then the follow by the following code

$test = @ ('SELECT count(*) FROM books');
if (!$test) {
die('<p>Error performing query: ' .
mysql_error() . '</p>');
}
echo $test;

somehow this doesn't work, it prints out: Resource id #23

someone please help check to see what is wrong with my code...thanks in advance 🙂

[laserlight]

$test contains the resource id, you need to obtain the result set from the result resource, e.g.

$test = @mysql_query ('SELECT count(*) AS book_count FROM books')
	OR die('<p>Error performing query: ' . mysql_error() . '</p>');
$row = mysql_fetch_array($test);
echo $row['book_count'];

[tanle]

thank you laserlight...you're genius...i feel so dumb hehehe:glare: