RE: [PHP-DB] order by date

2001-08-09 Thread Michael Rudel 

Hi Scott,

RTFM. Anyway: '... ORDER BY Date DESC' will do the job for you.

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:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___



> -Original Message-
> From: Scott Chapman [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 11:50 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] order by date
>
>
> Hi,
>
> I am querying a mysql database and am returning data ordered
> by date, the
> trouble is it returns the data from least recent to most
> recent, I want it
> to return the data the other way round.  Is there a way of
> having the mysql
> database doping this re-ordering for me rather than coding it myself?
>
> thanks
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] order by date

2001-08-09 Thread Dave Watkinson 

you can use order by date DESC 
for descending

or 

order by date
for ascending

nice to see a PHP-Database question in here ;-)


Dave


-Original Message-
From: Scott Chapman [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2001 10:50
To: [EMAIL PROTECTED]
Subject: [PHP-DB] order by date


Hi,

I am querying a mysql database and am returning data ordered by date,
the
trouble is it returns the data from least recent to most recent, I want
it
to return the data the other way round.  Is there a way of having the
mysql
database doping this re-ordering for me rather than coding it myself?

thanks




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] order by date

2001-08-09 Thread Scott Chapman 

Hi,

I am querying a mysql database and am returning data ordered by date, the
trouble is it returns the data from least recent to most recent, I want it
to return the data the other way round.  Is there a way of having the mysql
database doping this re-ordering for me rather than coding it myself?

thanks




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]