Just realised that my child value is not retrieving from mysql.
Both parent and child are saving to their respecitive values to my DB, but only parent is retrieving the value.
Here is code for Child
<select name="mem_town" id="mem_town">
<option value="" <?php if (!(strcmp("", (str_replace('"', '"', $row_WAATKmembertbl['mem_town']))))) {echo "selected=\"selected\"";} ?>>Select town</option>
<?php
do {
?>
<option value="<?php echo $row_rsTowns['Town_IDX']?>"<?php if (!(strcmp($row_rsTowns['Town_IDX'], (str_replace('"', '"', $row_WAATKmembertbl['mem_town']))))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsTowns['Town_Name']?></option>
<?php
} while ($row_rsTowns = mysql_fetch_assoc($rsTowns));
$rows = mysql_num_rows($rsTowns);
if($rows > 0) {
mysql_data_seek($rsTowns, 0);
$row_rsTowns = mysql_fetch_assoc($rsTowns);
}
?>
</select>
Am I missing something here?