Strange COUNT results

[Christopher Book <cbook@xxxxxxx>]

>>>>>I'm using PHP with mySQL and I got very weird results when I ran a
count. I used "SELECT COUNT(*) FROM $TableName", with $TableName being my
table's name, for the Query. >>>>>When I printed the result I got "Resource
id #2", what does that even mean. And what did I do wrong?.... 

You tried to print your result object.  Instead do this:

$query = "select count(*) as num from $tablename";
$result=mysql_query($query);
$obj=mysql_fetch_object($result);
$count=$obj->num;
print $count;
Chris




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92271@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php