RE: [PHP] Help getting count to show up.
| From: | David Freeman | Date: | Tue, 10 Sep 2002 23:04:11 +0000 |
| Subject: | RE: [PHP] Help getting count to show up. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-115903@lists.php.net to get a copy of this message | ||
> ex. SELECT feild1, field2, COUNT(*) FROM tables GROUP BY
> category, format.
Try this instead:
SELECT field1, field2, COUNT(*) AS field3 FROM TABLS GROUP BY
category,format
Now you'll find your count is available as 'field3'.
CYA, Dave