ok i already try this codings.. but the result is... all the controls are empty.. the drop down,textbox and the rest became empty.. conflict on mysql query i think..
mysql query:
if (isset($_GET['towname'])) {
$coldata_list_town_rec = $_GET['towname'];
}
mysql_select_db($database_mySQL, $mySQL);
$query_list_town_rec = sprintf("SELECT towname, num_brgy, townhistory, townborn, town_pop, general_info FROM tbltowns where towname LIKE %s ", GetSQLValueString("%" . $coldata_list_town_rec . "%", "text"));
$list_town_rec = mysql_query($query_list_town_rec, $mySQL) or die(mysql_error());
$row_list_town_rec = mysql_fetch_assoc($list_town_rec);
$totalRows_list_town_rec = mysql_num_rows($list_town_rec);
?>
<form action="/lcr8/townspots.php" method="post" name="formdropdown" id="formdropdown">
<label> </MM:DECORATION>
</MM_REPEATEDREGION>
<MM_REPEATEDREGION SOURCE="@@rs@@">
</label>
<span id="spryselect1">
<label>
<select name="towname" id="towname">
<option value="value">Select Municipality...</option>
<?php
do { ?>
<option value="<?php echo $row_list_town_rec['towname']?>"><?php echo $row_list_town_rec ['towname']?></option>
<?php
} while ($row_list_town_rec = mysql_fetch_assoc($list_town_rec));
$rows = mysql_num_rows($list_town_rec);
if($rows > 0) {
mysql_data_seek($list_town_rec, 0);
$row_list_town_rec = mysql_fetch_assoc($list_town_rec);
}
?>
</select>
</label>
<span class="selectRequiredMsg">Please select an item.</span> </span>
</form>