On Mon, 3 Aug 2009 11:52:11 +0200, Nisse Engström wrote:

> You could use the date as an index:
> 
>   ... SELECT DATE(`datetimecolumn`) AS `date` ...
> 
>   while ($TrackingRow = mysql_fetch_object (...)) {
>     $data[$TrackingRow['date']] = $TrackingRow;
>     /* Store the last row from each set of dates */
>   }
> 
> or
> 
>   while ($TrackingRow = mysql_fetch_object (...)) {
>     if (!isset ($data[$TrackingRow['date']])) {
>       $data[$TrackingRow['date']] = $TrackingRow;
>     }
>     /* Store the first row from each set of dates */
>   }

And, of course, if you want all rows to be indexed by date:

  while ($TrackingRow = mysql_fetch_object (...)) {
    $data[$TrackingRow['date']][] = $TrackingRow;
  }


/Nisse

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

Reply via email to