[PHP-DB] SUMMARY: sorting problem...

Hello All, Thanks for the all info !! I've done my query like this: SELECT id,SUBSTRING(FROM_UNIXTIME(unixtime),1,10) as unixtime,ip,porta_snmp,porta_switch,ip_cliente,mac_cliente from teste group by unixtime,porta_switch,porta_snmp; I've used SUBSTRING to get rid of the time from my

[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

Re: [PHP-DB] order by problem

Thank you all for the Tip ! It works fine now !! :) Gus - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:32 AM Subject: Re: [PHP-DB] order by problem On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote: You have

[PHP-DB] order by problem

Hello All, I´m having a 'problem' that I dont know how to resolve. The problem is: I have a table that I want to get the last number to increment. To do this I want to sort the filed 'ctrlnumber'. Using this query´s I get: mysql SELECT ctrlnumber FROM table WHERE id=14; ++ |