onchange not selecting the vaule I'm requesting and nothing show

[SeanKann]

The page loads up fine on my test server. but from the <option> select to select a cust name it refreshes the page but nothing showing on the page. Right now I'm tryin' to get it to just show the business_name below but nothing..

Only thing I want it to do is select a business name from the select option then show it on the same page.

Select a User
<form name='users'action='?submitname=true' method='post'>
	<select name='business_name' onchange='document.users.submit();'>
<?

include( 'connection.php' );

mysql_connect($dbhost,$dbuser,$dbpass) or die("Unable to connect to database");
@mysql_select_db("$dbname") or die("Unable to select database $dbname");

$query = "SELECT * FROM contacts";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
  {
echo '<option value="' . $row['id'] . '">' . $row['business_name'] . '</option>'; 
}
echo "</select>";
echo "</form>";

echo "<p>" .$row['business_name'] . "</p>";

mysql_close();

?>

[bpat1434]

You don't query for the business name that was selected. So you've got the proper code to "refresh" the page automatically (might I suggest adding an "update" button for those with javascript turned off?); however, once the page is submitted, you don't query to get the businessname which corresponds to the ID submitted.

So you'd need to do one of two things: Either (1) Use two queries in your code, one to list all businesses and the other to get the info on the selected business, or (2) use one query which gets all business data for all businesses and then save that info to an array, then loop through the array to generate your select list and then use the $_POST['business_name'] value to get the information from that array.

Either way will work.