Dynamic filling Form Fields

edzeak

I have the following code and I am attempting to dynamically complete the City and State fields, if there is a Location Code entered.

I am stuck, any advice would be great!

Thanks..

<Tr>
<Td>Location Code:</td>
<td>

				 	   <?php 

					   	$db = mysql_connect("localhost", "name", "password") or die
							("Couldn't connect to server.");

							mysql_select_db("trailerdamage",$db) or die ("Couldn't select database.");

							$result = mysql_query("SELECT * FROM locations Order by locationcode",$db);

							echo "<select name=loccode>";

							if ($myrow = mysql_fetch_array($result)) {

							do {	

							echo "<option value=$myrow[locationcode]>$myrow[locationcode]</option>\n";								
							$city = ($city);
							}	

							while ($myrow = mysql_fetch_array($result));

							echo "</select>";						

							}	

							?>								
	</td>
</tr>
<tr>
	<td>City: <font size="1" color="red">*Required</font></td>
	<td>
			<input type=text name=city value="<?php ("$city";) ?> "> 
		 </td>
</tr>
<tr>
	<td>State: <font size="1" color="red">*Required</font></td>
	<td><select name="state" value="<?php ("$state";) ?>>
		<option></option>			<option>CT</option>
		<option>DE</option>
		<option>IL</option>
		<option>IN</option>
		<option>MA</option>
		<option>MD</option>
		<option>NH</option>
		<option>NJ</option>
		<option>NY</option>
		<option>OH</option>
		<option>PA</option>
		<option>VA</option>
		<option>VT</option>
		<option></option>
	    </select>	
	</td>
</tr>

Anon

Are you trying to dynamically populate form drop-downs?

http://phpbuilder.com/columns/richard20010108.php3

edzeak

No. What I am doing is pulling the drop down list from a MySQL table and I have two more fields, the city and state in the table. Each location code has a specific city and state. If a user selects a specific Location Code, then I want the City and State to automatically be completed.

The only way I have found to make this work is to have the Location code query on one page and then pass that variable to another query on the second page where the City and State are retrieved and the <input> fields are updated appropriately.

If it is possible to do this on one page I would appreciate any ideas. Thanks for the website, I will be reviewing it today.

Anon

If you have field dependencies, and need to display them after the user makes a choice then either:

use javascript to display the other value(s) using layers. This, of course means worrying about javascript compatibility.......
display the city and state on the confirmation page.

Anon

Thanks for your advice. I have made this one page form into two pages and it is simplified this way. I don't want to use JavaScript because of the multitude of problems associated.

Thanks for the advice. I love this forum.