Taking this:
SELECT count(*) AS
CountUniqueDatesInMyTbl, date(solarAWDateTime) AS uniqueDate,
'aweber_7solar_aw' AS tableAlias FROM aweber_7solar_aw GROUP BY
DATE(solarAWDateTime)
Your query says:
get the date() from the solarAWDateTime field
then
group by that date
and give me the date and number of results
ie - you asked for the number of results per date - which is what you got.
You didn't ask for the number of unique dates.
yes. And in fact that was what I wanted.
I better quit for the day while I am ahead, and not spread around any more brain-fry now.
Thank you Chris, and all.
------------
John Butler (Govinda)
govinda.webdnatalk@gmail.com