Stopping the dropdown list keeps reverting back

[Anon]

Hi there,

I have 2 tables... one is 'address', the other called 'city'
'city' is a drop downlist with 'city' data...

The key between the two is city_id...

The problem is when I call the back the data I have inputted with addresses etc for correction or whatever, the city dropdown list reverts back to the top of selection list from the database... What would the code be that maintains the city info from the existing data on the database?

Thanks in advance,

Grant

[Anon]

here's some hurried pseudocode that suggests how i have implemented foreign key selector widgets in html:

class CitySelector {

$city2show;
$sql = "select city_id, city_nm from CITY";
$_db;

function CitySelector($city2show="") {
$this->city2show=$city2show;
$this->db=[get db connection, &c]
}

function psel($city2show="") {
if ($city2show)
$this->city2show=$city2show;
$resultset = $this->db->query($sql);
print "<select name=\"cities\">\n";
while ($resultset...) {
print "<option value=\"$id\"";
if ( $id == $this->_city2show )
print "selected";
print ">$name\n";
}
print "</select>\n";
}

}

to use:

<? $c = new CitySelector($form_var_id); ?>

<table>
<tr>...
...
<td><? $c->psel(); ?></td>
...
</table>

[Anon]

What Arthur is trying to say is that you can make your selectbox "pre-select" a value by adding "selected" in the "option" tag in your html:

<select name=city>
<option value="Amsterdam">
<option value="Brussels">
<option value="Paris" selected>
<option value="Moskow">
</select>

So, as you loop through your cities when you print your selectbox,
check if the city you are printing is the one you want to have selected.
If it is, print the word "selected" in your option trag.