RE: [PHP] Newbie Select Question

Ok, that works :) Thank you very much. -----Original Message----- From: Mark Maggelet [mailto:maggelet@mminternet.com] Sent: Saturday, 11 November 2000 2:56 PM To: gaur@planetveggie.com; php-general@lists.php.net Subject: Re: [PHP] Newbie Select Question On Sat, 11 Nov 2000 13:08:50 +1000, Chris Doyle (gaur@planetveggie.com) wrote: >the count is wrong.. it's not wrong, it's just missing a 'group by'. >Hi, >> Sorry to bother you with a minor question. There is probably some >>very >> simple answer :o >> >> Can you tell me why this is not working? >> SELECT u.id,u.perms,COUNT(*) FROM users u WHERE (u.perms & 16) AND >>u.id >NOT >> IN ($delstr) >> >> It returns this error: >> Error 1140 (Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with >>no GROUP >> columns is illegal if there is no GROUP BY clause) >> Session halted. >> >> Thanks, >> Matt > > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list- >admin@lists.php.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net