Re: Newbie Select Question
| From: | Mark Maggelet | Date: | Sat, 11 Nov 2000 04:56:18 +0000 |
| Subject: | Re: Newbie Select Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-24759@lists.php.net to get a copy of this message | ||
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