removing duplicates in select menus.

Discussion in 'Programming' started by cris02, Aug 24, 2006.

0
  1. #1
    hello,

    i have a code that query data on mysql then place the data on my selec menus, but there's i have problem, because there's are some data that are the same, now in my select menu i want to remove the duplicate that are place on my select menus? is there other way to do it... if you have any idea please help me... i appreciate your help.. thanks..
     
    cris02, Aug 24, 2006 IP
  2. kjewat

    kjewat Active Member

    Messages:
    149
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #2
    Do you want the sql query to return only distinct results? Then you can use SELECT DISTINCT...

    But first I would check if there is a logical error or something resulting in the duplicate rows.
     
    kjewat, Aug 25, 2006 IP
  3. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #3
    Generally when the use of Distinct is needed it means your SQL is not correct. Check the joins and make sure their not Left Outer Joins where they should be Inner Joins ;)
     
    ccoonen, Aug 25, 2006 IP