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