List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 9 2000 7:52pm
Subject:Re: Need help with query
View as plain text  
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
Thread
Need help with queryTyler Longren9 Sep
  • Re: Need help with queryPaul DuBois9 Sep
  • Re: Need help with queryTyler Longren9 Sep