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