invalid use of group function (mysql)
| From: | Alexander Ross | Date: | Fri, 26 Jul 2002 15:13:26 +0000 |
| Subject: | invalid use of group function (mysql) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-109744@lists.php.net to get a copy of this message | ||
Why am I getting this error? My statement is:
SELECT * FROM shots WHERE shot_num = MAX(shot_num) LIMIT 1;
There is one record in the table "shots". Its shot_num value is 0.