Dont repeat value

[darko886]

Hi, I am trying to make 3 dropdown menus that populate each other depending on what is chosen. Anyway, they will populate each other with the corresponding MySQL field. So for example, if somebody were to pick under "Aircraft" Aircraft1 then it will populate the 2nd dropdown etc. Anyway, I am trying to use:

$num_rows = mysql_num_rows($result); 

and

while ($row = mysql_fetch_assoc($result))

and

.$row['aircraft'].

I am wanting to use those to populate the Aircraft dropdown menu with all of the aircraft, the only problem is I do not want the same Aircraft to repeat. For example if there are 15 entries with Aircraft1 I want the list only to have one Aircraft1 in it... Please help me with this.
Thanks!
Darko

[laserlight]

It sounds like you want a SELECT DISTINCT query.

[darko886]

Thats exactly what i needed! Thanks 🙂

[bradgrafelman]

Don't forget to mark this thread resolved (using the link on the Thread Tools menu).