guess you can better take a look at the group by function of mysql -----Original Message----- From: Ignatius Reilly [mailto:ignatius.reilly@free.fr] Sent: donderdag 13 maart 2003 15:03 To: guslist@kerntec.net; php-db@lists.php.net Subject: Re: sorting problem... Take a look at the MySQL DATE_FORMAT() function. Ignatius ____________________________________________ ----- Original Message ----- From: <guslist@kerntec.net> To: <php-db@lists.php.net> Sent: Thursday, March 13, 2003 2:43 PM Subject: sorting problem... > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
