RE: [PHP] odrer by alphabet
| From: | Smith, Benjamin | Date: | Tue, 04 Dec 2001 02:09:40 +0000 |
| Subject: | RE: [PHP] odrer by alphabet | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76451@lists.php.net to get a copy of this message | ||
You can simply order by that field in your SQL string...ie:
SELECT * FROM TABLENAME ORDER BY FIELDNAME;
And to switch the order:
SELECT * FROM TABLENAME ORDER BY FIELDNAME DESC;
-----Original Message-----
From: Rambo Amadeus [mailto:avdija@epn.ba]
Sent: Tuesday, 4 December 2001 1:15 PM
To: php-general@lists.php.net
Subject: [PHP] odrer by alphabet
hi, i have about 100 names in my database. How should i list them by
alphabet.
Thanks
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net