> 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
--
PHP General Mailing List (http://www.php.n
, September 10, 2002 3:25 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Help getting count to show up.
Hi,
Last night I asked for help doing counts. One of the answers I got was
really great but I can't make it work. The answer I more or less show me a
great way to create a stats page,
ex. SELECT f
Hi,
Last night I asked for help doing counts. One of the answers I got was
really great but I can't make it work. The answer I more or less show me a
great way to create a stats page,
ex. SELECT feild1, field2, COUNT(*) FROM tables GROUP BY category, format.
But my problem is I can't get count
3 matches
Mail list logo