sorting problem...
| From: | guslist at kerntec dot net | Date: | Wed, 12 Mar 2003 18:54:42 +0000 |
| Subject: | sorting problem... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-139357@lists.php.net to get a copy of this message | ||
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