php获取mysql count返回,MySQL PHP count（*）返回奇怪的东西

I'm running the following query, expecting it to return an INTEGER, but it returns "Resource id #3"

What am I doing wrong?

$queryPlans = mysql_query("SELECT count(*) FROM infostash.rooms");

echo $queryPlans;

There are actually 15 rows in this table, and I would like to return the number 15.

Any suggestions?

解决方案

You need:

$queryPlans = mysql_query("SELECT count(*) FROM infostash.rooms");

$row = mysql_fetch_array($queryPlans);

echo $row[0];

mysql_query() isn't returning the result. It's returning a resource you can loop across and interrogate for rows (as above).