Is there a way to extract lets say a bunch of dates from a mysql db, and
the sort them in order from newest to oldest? Also how would you sort
names in alphabetical order?
~Cleeker
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, 20 May 2002, Cleeker wrote:
Is there a way to extract lets say a bunch of dates from a mysql db, and
the sort them in order from newest to oldest? Also how would you sort
names in alphabetical order?
Read the section of the MySQL manual that covers ORDER BY clauses.
miguel
--
PHP
the 'ASC' with 'DESC'.
Tyler Longren
Captain Jack Communications
www.captainjack.com
[EMAIL PROTECTED]
- Original Message -
From: Cleeker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 9:11 PM
Subject: [PHP] MySQL and sorting
Is there a way to extract lets say a bunch
On Tuesday 21 May 2002 10:11, Cleeker wrote:
Is there a way to extract lets say a bunch of dates from a mysql db, and
the sort them in order from newest to oldest? Also how would you sort
names in alphabetical order?
Yes, look at the date/time functions in the (mysql) manual.
--
Jason Wong
Is there a way to extract lets say a bunch of dates from a
mysql db, and the sort them in order from newest to oldest?
Also how would you sort names in alphabetical order?
Yes, and a php list is obviously a good place to ask an sql question.
In any case, you want to examine your
5 matches
Mail list logo