Re: Newbie Select Question
| From: | Matt | Date: | Sat, 11 Nov 2000 18:40:04 +0000 |
| Subject: | Re: Newbie Select Question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-24791@lists.php.net to get a copy of this message | ||
You need Count(table.*) since you are using multiple tables
----- Original Message -----
From: "Chris Doyle" <gaur@planetveggie.com>
To: "PHP List" <php-general@lists.php.net>
Sent: Friday, November 10, 2000 10:08 PM
Subject: Re: [PHP] Newbie Select Question
> 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
>
>
>
> --
> 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
>