Re: alphabetical order

woa that was a real quick help :) thx alot "Beau Lebens" <beau@insurancemyway.com.au> wrote in message news:5.0.0.25.2.20010308155354.024a2440@mail.insurancemyway.com.au... > 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"" <eyilmaz76@ultratv.net> wrote in message > >news:987dse$svd$2@toye.p.sourceforge.net... > > > 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: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > 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: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >