Dynamic Menu Selection

[lmayer4]

Afternoon,

I found an earlier post that almost gets me what I need. Although my fooling around with it keeps taking down my test server.

First I broke it when I tried to make the select menu do 'selected'. Then I broke it again when I tried to wrap an input text box into a while loop.

If anyone can take a look I would be most apprciative.

Thanks as always: Laura

<?php
include ("UpLoad/connect.php");
$load_sql = "SELECT Facility,FacilityID FROM tblLocation";
if (isset($_POST['cust']))
	{
    $load_sql .= " WHERE FacilityID='".$_POST['cust']."'";
	}
	$main_query = mssql_query($load_sql);
	$users = array();
while(($fetch = mssql_fetch_array($main_query)) !== FALSE)
		{
		$users[] = $fetch['FacilityID'];
		}
?>
<form name="frm" action="<?PHP echo $_SERVER['PHP_SELF']; ?>?view=cust" method="POST">
<table>
<tr><td>Facility Name:</td>
<td>
<?php
$sql = mssql_query("SELECT FacilityID, Facility from tbllocation");
echo "<select name=cust size=1 onChange='frm.submit();'>";
while ($row = mssql_fetch_assoc($sql)) 
{   

		$facilityid = $row['FacilityID'];
		$facility = $row['Facility'];
		echo '<option value="'.$facilityid.'">'.$facility.'</option>';
}
echo "</select></td></tr>";
?>
<tr><td>FacilityID:</td>
<td>
<?php
echo '<input type="text" name="address" value="';
echo $fetch['FacilityID'];
echo '">';
?>
</td>
</tr>
</table>    

[devinemke]

lmayer4 wrote:

I found an earlier post that almost gets me what I need.

but you have never said what you "need".

[lmayer4]

Sorry about that.

I need a drop down menu that when you select an item it populates the text box below it. The select menu needs to stay selected, thats the piece that keeps breaking. I can't make it select only the one item, it selects all. Then on the text box that's the very bad peice. It keeps taking down the server, blue screen and all. There's something about the while loop it doesn't like.

Thanks

Laura

[devinemke]

a simple example:

<?php
$array = array(1,2,3,4,5);

echo '
<form action="" method="POST">
<select name="num">
';

foreach ($array as $value)
{
	echo '<option';
	if (isset($_POST['num']) && $_POST['num'] == $value) {echo ' selected';}
	echo '>' . $value;
}

echo '
</select><br>
<input type="text" name="text" value="'; if (isset($_POST['num'])) {echo $_POST['num'];} echo '"><br>
<input type="submit" name="submit" value="submit">
</form>
';
?>