RE: [PHP] Help getting count to show up.

2002-09-10 Thread David Freeman
> 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

RE: [PHP] Help getting count to show up.

2002-09-10 Thread David Buerer
, 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

[PHP] Help getting count to show up.

2002-09-10 Thread Chuck Payne
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