Problem solved, thanks!

"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"" <aemuli@spamclause-yahoo.com> wrote in message news:9b6229$48j$1@toye.p.sourceforge.net... > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >