PC

Thanks for your quick response. Worked a treat except that it passes the position in the box rather than the city_id value. Any ideas? Thanks

I have the following code for populating a combo box: echo "<td>City Search:</td>"; echo "<td><select Name=A_City>"; for($i=0;$i<=$nbcities;$i++) { echo "<option value=".$cityset[CITY_ID][$i].">".$cityset[CITY_NAME][$i]."</option>\n"; echo "</select>"; Unfortunately the first city is correct but the second and subsequent ones aren't in the list but on the screen to the right and therefore not selectable. Can anyone advise where I am goig wrong please? Thanks Paul

Thanks. Sorted noiw. Paul

Hi All this is not actually a table. the result set is an array and when I load the page I get array repeated many times down the page. Any ideas? Thanks Paul

Hi All I am trying to populate a combo box from an oracle table. I have generated a result set that contains an Id field and a City field. How do I get the contents of the result set into the combo box in such a way that the selected city id is then posted? Thanks Paul