Works in MySQL but not on the php page?

[austinderrick2]

SELECT username, MAX(score) as biggest FROM `table` GROUP BY username

or in my php code:

     $query = "SELECT username, MAX(score) as biggest FROM `table` GROUP BY username";
     $result = mysql_query ($query,$connection);
     while ($row = mysql_fetch_object($result)){
     }

This works in phpmyadmin but in my phpcode it gives me this error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in page.php on line 47

It does everything correctly it just displays that ugly error.

[tekky]

maybe the fact that MAX is a PHP function also.... but I dont see that causing a problem... try replacing the double quotes with single quotes ' so that the str is taken as a literal

[drawmack]

a trick I use to debug sql in any language is to echo out the sql statement from the program to the screen like this.

$sql = "my sql code";
echo $sql;
mysql_query($sql);

[ccgorman]

Just a complete guess, I have not looked into mysql_fetch_object, but try mysql_fetch_array instead.

-Chris