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

SELECT feild1, field2, COUNT([insert field name here]) FROM tables GROUP BY category,format --or-- SELECT feild1, field2, COUNT([insert field name here]) as mycount FROM tables GROUP BY category,format -Original Message- From: Chuck Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

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

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