drop down showing name twice

timmybuck

I have a drop down menu, the menu contains names of places.

When i add more then 1 event name to be displaed when a place is selected, it updates my drop down and lists the same place twice or more depending on how many events i have added.

This is the code that displays the name of places

<?php
$event_county= $dbcon->getResultOf("SELECT eventCounty FROM kiyx_event");
print("<select name=\"eventCounty\" size=1>\n");
print("<option value=\"b\">Select");
print("<option value=\"b\">-----");
while($row1 = mysql_fetch_array ($event_county))
{
print("<option value=\"$row1[eventCounty]\">$row1[eventCounty] \n");
}
print("</select>\n");

any support appreciated

laserlight

Might try:
SELECT DISTINCT eventCounty FROM kiyx_event

Incidentally, you might want to consider placing the eventCountry data in a separate table, then use an appropriate key to access it in kiyx_event

timmybuck

thanks for the tips

timmybuck

thanks for the tip laserlight, the sql works that you suggested.

Whatr would i need to add if i wanted it so that there was a search 'All' option in the event counties field.

i need to construct some sql that would search all fields right ?
and put the 'All' option in the drop down, right?

timmybuck

can anyone help

Frederick

you can set a variable to modify the query string

if ($eventCounty == "all"; ) { $query = "eventCounty"; }
else { $query = "DISTINCT eventCounty"; }

SELECT ".$query." FROM kiyx_event