Re: MySQL query or Filter code

hi, just use DISTINCT in your case: SELECT DISTINCT type FROM code; andreas Hi everybody, I've got a table named code. In this table there is a column named type. I'm gettting the different types from the database, and putting them on a website. Sometimes, there's more than one entry for the same thing in type. Example: name type id Tyler Longren HTTP 1 EditDelete Tyler Longren Database 2 EditDelete Tyler Longren Filesystem 3 EditDelete Tyler Longren Filesystem 4 EditDelete See how there's 2 entries for the Filesystem type? How can I make it so it only puts one of those out onto the webpage? So when you view the page it looks like this: HTTP Database Filesystem Instead of: HTTP Database Filesystem Filesystem Can I do this with just a MySQL query or would I have to filter my code somehow? If I have to filter the code, could you provide an example? Thanks. Regards, Tyler Longren