Hi All, I need to sort some data from a MySQL table. I have data saved like this: +----+---------------------+------------+--------------+ | id | unixtime | porta_snmp | porta_switch | +----+---------------------+------------+--------------+ | 1 | 2003-01-07 12:23:24 | 1614 | 1 | | 2 | 2003-01-07 12:24:01 | 1614 | 1 | | 3 | 2003-01-07 12:29:34 | 1614 | 1 | | 4 | 2003-01-07 12:30:19 | 1614 | 1 | | 5 | 2003-01-07 12:31:01 | 1614 | 5 | | 6 | 2003-01-07 12:32:06 | 1614 | 5 | | 7 | 2003-01-07 12:33:01 | 1614 | 1 | | 8 | 2003-02-07 12:34:06 | 1614 | 1 | | 9 | 2003-02-07 12:35:00 | 1614 | 1 | | 10 | 2003-02-07 12:36:01 | 1614 | 1 | +----+---------------------+------------+--------------+ I neet to sort the data to be able to read it better. In this case I just need to filter the data to get only the different info for each day. Some thing like this: 2003-01-07 1614 1 2003-01-07 1614 5 2003-02-07 1614 1 Is this possible ? Thank's in advance, Gus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
