[RESOLVED] Resource id #4

maexus

I tried seaching for it but nothing came up.

Here is my code:

<?php

connect();

$count = mysql_query("SELECT COUNT(*) FROM ".cTABLE);

if (mysql_num_rows($count) != 0)

{
	echo '<p>'.$count.' Links Shrunk So Far...</p>';
}

else

{
	echo 'No links have been shrunk yet';
}
?>

I don't really know anything about the COUNT function for queries. And still pretty new to the database scene really. $count displays as Resource id #4 :bemused:

bbreslauer

What is returned from mysql_query is something called a "resource", or a "resource link", which is the link to the database. You need to call another function (like mysql_fetch_assoc()) on $count in order to get any meaningful data out of the database call. You can find information on this function at php.net, along with other functions that do the same type of thing.

Roger_Ramjet

That is because $count IS the Resultset known as Resource#4

You need to address the Contents of $count

connect();

$count = mysql_query("SELECT COUNT(*) FROM ".cTABLE);

if (mysql_num_rows($count) != 0)

{
	echo '<p>'. mysql_result($count, 0) .' Links Shrunk So Far...</p>';
}

else

{
	echo 'No links have been shrunk yet';
}

Lots of other ways of addressing the results.