On Sun, Aug 2, 2009 at 8:02 PM, Govinda<govinda.webdnatalk@xxxxxxxxx> wrote: >> >> You need to do this on the mysql side, not in php - php can't summarize >> the data before processing it, so you need to use something like the date() >> function in mysql on your timestamp column. >> >> >> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date >> >> without knowing your original query it's hard to give an example, but: >> >> select distinct date(timestamp_column) from table; > > Thanks Chris, > > I am getting closer, but so far it is not iterating only once per unique > 'date part of the datetime expression', it is returning all the rows in the > table, including those with the very same date but different time in the > value of the 'solarLandingDateTime' column. There is not alot of discussion > in the mysql docs that I saw about how to work with DISTINCT. I need to > grab data out of the 3 columns: solarLandingIP, solarLandingDir, > solarLandingDateTime (this part of my SELECT is working). > > This is what I have: > > $foundTrackingRows=mysql_query("SELECT DISTINCT DATE(solarLandingDateTime) > solarLandingIP, solarLandingDir, solarLandingDateTime FROM ".$whichTable." > ORDER BY solarLandingDateTime DESC LIMIT $Maxrecs2Show") or die("query > failed: " .mysql_error()); > > -Govinda try foundTrackingRows=mysql_query("SELECT DISTINCT DATE_FORMAT('%Y-%m,%d',solarLandingDateTime) solarLandingIP, solarLandingDir, solarLandingDateTime FROM ".$whichTable." ORDER BY solarLandingDateTime DESC LIMIT $Maxrecs2Show") or die("query failed: " .mysql_error()); -- Bastien Cat, the other other white meat -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
