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.webdnat...@gmail.com

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to