SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot prashidi's Avatar
    Join Date
    Mar 2001
    Posts
    118
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    distinguishing word from database once.

    Hi everyone,

    I am trying to get a word from the database that has been used several times to be printed only once.

    This is how it looks like:

    http://www.3ddrivers.com/drivers.php?action=man&id=3

    and

    http://www.3ddrivers.com/drivers.php...cman&pman=3COM

    and

    http://www.3ddrivers.com/drivers.php...work%20Devices

    all can be fixed by one thing.

    As you can see I have entered 3COM in to the database 4 times for each product that has been entered. How do i go about distinguishing between the similar ones and outputting it only once.

    Thanks.

  2. #2
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use DISTINCT in your query

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •