'order by text asc' will sort in alphabetical order A-Z
.. and your query should be select [campo] from table where campo like 'A%'
... seems like an expensive way of sorting ...
i think mysql has natural order sorting functions in there somewhere ...
Steve
"Marisol díaz e." <[EMAIL PROTECTED]> wrote in message
000e01c1113b$5df255f0$[EMAIL PROTECTED]">news:000e01c1113b$5df255f0$[EMAIL PROTECTED]...
> select [campo] from [tabla] order by [campo]
>
> if you want for each leter
>
> select [campo] from [tabla] where [campo] like 'A'
>
> Marisol
> ----- Original Message -----
> From: "Erich Kolb" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, July 20, 2001 11:32 AM
> Subject: [PHP] PHP & MySQL
>
>
> > When you query a MySQL Database, how do you set the order
alphabetically?
> >
> > --
> > 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]
