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:[EMAIL PROTECTED]] Sent: Tuesday, 4 December 2001 1:15 PM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General 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]
