[RESOLVED] strange result from count(*)

[lglben]

When 'SELECT COUNT(*) FROM urltbl' is performed on an empty table, the result is not a number (0), but the string 'Resource id #4'. What does this mean?

[lglben]

OK. I found out the answer myself, but I'll post it here in case it helps anyone else.

My code was like :

$result=mysql_query('SELECT COUNT(*) FROM urltbl');

then I just tried to echo $result; but it needs to be accessed like, for example,

while ($row=mysql_fetch_array($result)) {
echo $row;
}

...even though the result is only one row.