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

2001-04-12 Thread Jason N. Perkins
> 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

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

2001-04-12 Thread Jason N. Perkins
> 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.somebod

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

2001-04-12 Thread Jason N. Perkins
> 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.someb

[PHP] crap! look at the mess that i made!

2001-04-12 Thread Jason N. Perkins
sorry about all the posts...i was getting a message that an error had occured and my message wouldn't be posted. like a dumbass i took it at face value... -- :: jason n. perkins :: email -> jason[at]somebodydial911.com :: url -> www.somebodydial911.com :: "for a vegetarian