Re: [PHP-DB] alphabetical order
i am using mysql :) ""karakedi"" [EMAIL PROTECTED] wrote in message 987dse$svd$[EMAIL PROTECTED]">news:987dse$svd$[EMAIL PROTECTED]... hi there, i ve created a database. there are two rows in it, one is "id" and the other consists of "film names". i ve managed to list and print them out sorting by ids, but i just wonder if there is a way to sort them in alphebetical order. any example is high appreciated. thx in adv. -- 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] alphabetical order
you should be able to do this exactly the same as you have the id SELECT * FROM film_details ORDER BY film_names ASC should sort by the film name, 'A' first, up to 'Z' if that doesn't work, perhaps get all the results, drop them into an array and then sort the array, then process the array. HTH Beau At 09:59 AM 3/8/01 +0200, karakedi wrote: i am using mysql :) ""karakedi"" [EMAIL PROTECTED] wrote in message 987dse$svd$[EMAIL PROTECTED]">news:987dse$svd$[EMAIL PROTECTED]... hi there, i ve created a database. there are two rows in it, one is "id" and the other consists of "film names". i ve managed to list and print them out sorting by ids, but i just wonder if there is a way to sort them in alphebetical order. any example is high appreciated. thx in adv. -- 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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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] alphabetical order
woa that was a real quick help :) thx alot "Beau Lebens" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... you should be able to do this exactly the same as you have the id SELECT * FROM film_details ORDER BY film_names ASC should sort by the film name, 'A' first, up to 'Z' if that doesn't work, perhaps get all the results, drop them into an array and then sort the array, then process the array. HTH Beau At 09:59 AM 3/8/01 +0200, karakedi wrote: i am using mysql :) ""karakedi"" [EMAIL PROTECTED] wrote in message 987dse$svd$[EMAIL PROTECTED]">news:987dse$svd$[EMAIL PROTECTED]... hi there, i ve created a database. there are two rows in it, one is "id" and the other consists of "film names". i ve managed to list and print them out sorting by ids, but i just wonder if there is a way to sort them in alphebetical order. any example is high appreciated. thx in adv. -- 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] -- Beau Lebens - Web Master Insurance My Way, Your Friendly Online Broker (08) 9226 5888 http://www.insurancemyway.com.au/ -- 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]