Re: [PHP] Getting one of each result from MySQL

> The thing is, I want to have only one entry for each guild, and I want them > to be in alphabetical order. try the following sql: "select distinct guild from tablename order by guild" -- :: jason n. perkins :: email -> jason[at]somebodydial911.com :: url -> www.somebodydial911.com :: "for a

Re: [PHP] Getting one of each result from MySQL

> The thing is, I want to have only one entry for each guild, and I want them > to be in alphabetical order. try the following sql: "select distinct guild from tablename order by guild" -- :: jason n. perkins :: email -> jason[at]somebodydial911.com :: url -> www.somebodydial911.com :: "for a

Re: [PHP] Getting one of each result from MySQL

> The thing is, I want to have only one entry for each guild, and I want them > to be in alphabetical order. try the following sql: SELECT DISTINCT guild FROM tablename ORDER BY tablename -- :: jason n. perkins :: email -> jason[at]somebodydial911.com :: url -> www.somebodydial911.com :: "for a

[PHP] Getting one of each result from MySQL

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.