Text box based on list menu selection

rafik

Hi,

I have a php form page that creates a user account by inserting into MySQL.

Users must select their STATE from a list menu. State is being populated from a table. (see code below)

I would like a hidden text box for REGION to get populated (before submit) based on the STATE the user has selected in the list box.

Here's the list menu code:
<select name="STATE" id="STATE"><?php
do {
?>
<option value="<?php echo $row_rsState['STATE']?>"><?php echo $row_rsState['STATE']?></option>
<?php
} while ($row_rsState = mysql_fetch_assoc($rsState));
$rows = mysql_num_rows($rsState);
if($rows > 0) {
mysql_data_seek($rsState, 0);
$row_rsState = mysql_fetch_assoc($rsState);
}
?>
</select>

So the two fields are STATE (visible) & REGION (hidden).
As an example, if a user selects "North Carolina" in the list menu, the hidden field will populate with "South East".

PLEASE HELP!!??

Thanks,
Rafik

mogster

Well, this is easy using javascript, but what are your regions and where are they defined?

First: Name your form:

<form name="myselect" method="post" action="somescript.php">

Then create a js with a function to be executed onChange (of the select):

<SCRIPT language="JavaScript">
<!--
function doRegion() {
if(document.myselect.STATE.value = Alabama) {
/* And so on - here you need to specify the regions */
document.myselect.region.value = Midwest;
} else if (document.myselect.STATE.value = California) {
document.myselect.region.value = Westcoast;
}
}
//-->
</SCRIPT>

Then change the select code:

<select name="STATE" id="STATE" onChange="doRegion()">

and add a hidden field region (set it with a default value to ignore if user have disabled js...)

<input type="hidden" name"region" value"no_js">

knutm

mogster

Tip:
If you change the type of the region-field from hidden to text while you test this, you won't have to submit the form to see if it works 😉

knutm

rafik

Thanks for your prompt help!!

You got me started in the proper direction. The first and third part of your reply are correct, but I had to debug the function in part two to make it work.

I finally got the code to work like so:
<script language="JavaScript" type="text/JavaScript">
<!--
function doRegion() {
if (document.FORM-NAME.STATE.value == "Alabama") {
document.FORM-NAME.REGION.value = "South East";
}
else if (document.FORM-NAME.STATE.value == "Connecticut") {
document.FORM-NAME.REGION.value = "North East";
}

...and so on....

}
//-->
</script>

Bt the way, your suggestion to NOT make the text field hidden was a GREAT idea!!

Rafik