Re: Order by unix timestamp

Vielen Dank "Michael Rudel" <mru@suchtreffer.de> schrieb im Newsbeitrag news:02bb01c10ae5$38128190$2c00a8c0@suchtreffer.de... > 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 > _______________________________________________________________ > > Suchtreffer AG > Bleicherstraße 20 > D-78467 Konstanz > Germany > fon: +49-(0)7531-89207-17 > fax: +49-(0)7531-89207-13 > e-mail: mailto:mru@suchtreffer.de > internet: http://www.suchtreffer.de > _______________________________________________________________ > > > > > -----Original Message----- > > From: Andreas Iwanowski [mailto:aimk@onlinehome.de] > > Sent: Thursday, July 12, 2001 5:09 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] Order by unix timestamp > > > > > > 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 unixtime, but beginning with the oldest record. > > i thougt i could fix it by using ORDER by !unixtime . > > > > Also does'nt work > > > > How can i fix the problem that the records are ordered by unixtime, > > beginning with the newest record ? > > > > -- > > > > > > mfg, andy > > > > ----------------------------------------- > > In Memoriam - Jaques > > www.amdclan.de/jaques > > ------------------------------------------ > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > >