At 11:36 AM -0700 09-09-2000, Tyler Longren wrote:
>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
>
>Thanks for any help you may be able to give me.
SELECT DISTINCT type FROM code
--
Paul DuBois, paul@stripped
