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]