Re: Newbie Select Question
| From: | Chris Doyle | Date: | Sat, 11 Nov 2000 03:08:50 +0000 |
| Subject: | Re: Newbie Select Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-24751@lists.php.net to get a copy of this message | ||
the count is wrong..
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