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
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,
>
>
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