php-db | 2001071
Date: 07/12/01
- Next message: Rankin, Randy: "[PHP-DB] Escaping &"
- Previous message: Andreas Iwanowski: "[PHP-DB] Order by unix timestamp"
- In reply to: Andreas Iwanowski: "[PHP-DB] Order by unix timestamp"
- Next in thread: Andreas Iwanowski: "Re: [PHP-DB] Order by unix timestamp"
- Reply: Andreas Iwanowski: "Re: [PHP-DB] Order by unix timestamp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <email protected>
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Andreas Iwanowski [mailto:aimk <email protected>]
> Sent: Thursday, July 12, 2001 5:09 PM
> To: php-db <email protected>
> 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 <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Rankin, Randy: "[PHP-DB] Escaping &"
- Previous message: Andreas Iwanowski: "[PHP-DB] Order by unix timestamp"
- In reply to: Andreas Iwanowski: "[PHP-DB] Order by unix timestamp"
- Next in thread: Andreas Iwanowski: "Re: [PHP-DB] Order by unix timestamp"
- Reply: Andreas Iwanowski: "Re: [PHP-DB] Order by unix timestamp"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

