thx :)
"Robert Gormley" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> SELECT * FROM films ORDER BY filmname ASC;
>
> Robert
>
> At 09:57 AM 8/03/2001 +0200, karakedi wrote:
> >hi there,
> >i ve created a database. there are two rows in it, one is "id" and the
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,
SELECT * FROM films ORDER BY filmname ASC;
Robert
At 09:57 AM 8/03/2001 +0200, karakedi wrote:
>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
>ther
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.
H
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
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.
--
PH