Re: [PHP-DB] Order by unix timestamp

2001-07-12 Thread leo g. divinagracia iii
try the RSORT (reserve sort) function??? Andreas Iwanowski wrote: > > Hello, > i have a table where unix timestamps are inserted when adding a record. > > If i read out the table data, i want to order it by unixtime ( the name of > the filed where the timestamp is ) > > He orders it by unixti

Re: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Andreas Iwanowski
Thank you "Steve Brett" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > -Original Message- > > From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]] > > Sent: 12 July 2001 16:09 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Order by unix times

Re: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Andreas Iwanowski
Vielen Dank "Michael Rudel" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 02bb01c10ae5$38128190$[EMAIL PROTECTED]">news:02bb01c10ae5$38128190$[EMAIL PROTECTED]... > ORDER BY unixtime DESC > > (it default orders by asc, not desc) > > Greetinx, > Mike > > Michael Rudel > - Web-Development, Systemadmi

RE: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Steve Brett
> -Original Message- > From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]] > Sent: 12 July 2001 16:09 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Order by unix timestamp > > > How can i fix the problem that the records are ordered by unixtime, > beginning with the newest record ? orde

RE: [PHP-DB] Order by unix timestamp

2001-07-12 Thread Michael Rudel
ORDER BY unixtime DESC (it default orders by asc, not desc) Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - Besuchen Sie uns am 20. und 21. August 2001 auf der online-marketing-düsseldorf in Halle 1 Stand E 16 ___