[RESOLVED] Query generation redux

gotissues68

Hey All-
Thanks to Liquorvicor I was able to solve one of my other query questions so I have one more that I'm beating my head over.

I'm using the following query:

mysql> select distinct report_date, 45 Day ATS,count(45 Day ATS) as numrows from ohsnap where report_date like '%1/1/2007%' and 45 Day ATS > 4 group by report_date order by numrows DESC;
+-------------+------------+---------+
| report_date | 45 Day ATS | numrows |
+-------------+------------+---------+
| 40 | 221 |
+-------------+------------+---------+
1 row in set (0.00 sec)

Its returning the correct count for 45 Day ATS but the report date is being returned improperly due to how I've constructed the query.

What I need to do is the following:

Select distinct dates from the report_date field and then do a count on 45 Day ATS for each date and return the result set.

Can anyone clue me into how I'm constructing this one wrong?

Thanks!
Drew-

gotissues68

Hmm this query works fine..

select distinct report_date, count(45 Day ATS) as numrow
s from ohsnap where 45 Day ATS > 4 group by report_date DESC

I got hung up on the fact that for some reason in the MySQL cli it didn't show up properly but when I php'd it out it works fine and gives me the results I want ..

bleh its monday!

Thanks to everyone who took the time to look :-)