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@xxxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
