guess you can better take a look at the group by function of mysql
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]
Sent: donderdag 13 maart 2003 15:03
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] sorting problem...
Take a look at the MySQL DATE_FORMAT() function.
Ignatius
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 2:43 PM
Subject: [PHP-DB] 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-0716141
2003-01-0716145
2003-02-0716141
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