"distinct" and "order by" are all I need.
Thanks to John Keith and John Perkins for their quick answers!
--
Plutarck
Should be working on something...
...but forgot what it was.
""Plutarck"" <[EMAIL PROTECTED]> wrote in message
9b6229$48j$[EMAIL PROTECTED]">news:9b6229$48j$[EMAIL PROTECTED]...
> I need to query a MySQL database with something like: "select guild from
> table_name"
>
> I'm going to take "guild" and eventually make a drop-down box with the
> information, but that I can handle.
>
> The thing is, I want to have only one entry for each guild, and I want
them
> to be in alphabetical order.
>
> My current idea is to read all the results into an array with a while
loop,
> then use array_unique on it, then run sort on that.
>
> Is this really the best way to do it, or am I missing a simpler solution?
>
>
>
> --
> Plutarck
> Should be working on something...
> ...but forgot what it was.
>
>
>
> --
> 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]
