Untitled

<html>

<head>

<title>

</title>

</head>

<body>

<b>Select your favorite fruit or vegetables.</b><br/>
 <form name="locate" method="POST"

    action="<?php echo $_SERVER['PHP_SELF']?>">
<input type="radio" name="produce" value="apples" /> Apples<br />

<input type="radio" name="produce" value="oranges" /> Oranges<br />

<input type="radio" name="produce" value="bananas" /> Bananas<br />


<p>

<b>Select your state:</b><br/>

<select name="state">

<option value="AL">Alabama</option>

<option value="AK">Alaska</option>

<option value="AZ">Arizona</option>

<option value="AR">Arkansas</option>

<option value="CA">California</option>

<option value="CO">Colorado</option>

<option value="CT">Connecticut</option>

<option value="DE">Delaware</option>

<option value="DC">District of Columbia</option>

<option value="FL">Florida</option>

<option value="GA">Georgia</option>

<option value="HI">Hawaii</option>

<option value="ID">Idaho</option>

<option value="IL">Illinois</option>

<option value="IN">Indiana</option>

<option value="IA">Iowa</option>

<option value="KS">Kansas</option>

<option value="KY">Kentucky</option>

<option value="LA">Louisiana</option>

<option value="ME">Maine</option>

<option value="MD">Maryland</option>

<option value="MA">Massachusetts</option>

<option value="MI">Michigan</option>

<option value="MN">Minnesota</option>

<option value="MS">Mississippi</option>

<option value="MO">Missouri</option>

<option value="MT">Montana</option>

<option value="NE">Nebraska</option>

<option value="NV">Nevada</option>

<option value="NH">New Hampshire</option>

<option value="NJ">New Jersey</option>

<option value="NM">New Mexico</option>

<option value="NY">New York</option>

<option value="NC">North Carolina</option>

<option value="ND">North Dakota</option>

<option value="OH">Ohio</option>

<option value="OK">Oklahoma</option>

<option value="OR">Oregon</option>

<option value="PA">Pennsylvania</option>

<option value="RI">Rhode Island</option>

<option value="SC">South Carolina</option>

<option value="SD">South Dakota</option>

<option value="TN">Tennessee</option>

<option value="TX">Texas</option>

<option value="UT">Utah</option>

<option value="VT">Vermont</option>

<option value="VA">Virginia</option>

<option value="WA">Washington</option>

<option value="WV">West Virginia</option>

<option value="WI">Wisconsin</option>

<option value="WY">Wyoming</option>

</select>

<p>

<b>Enter your 5 digit zip code:</b><br/>


<input name="zip" maxlength="5" size="6" type="text" />

<input type="submit" value="Search" />

</form>

<p>

<?php

 var_dump($_POST);
if(isset($_POST['action']) && $_POST['action'] == 'submitform')
{
	//recieve the variables

	$produce = $_POST['produce'];
	$state = $_POST['state'];
	$zip = $_POST['zip'];

$db_host = 'localhost';

$db_user = 'root';

$db_pwd = 'password';


$database = 'hello_world';

$table = 'TBL_NAME';


if (!mysql_connect($db_host, $db_user, $db_pwd))

    die("Can't connect to database");


if (!mysql_select_db($database))

    die("Can't select database");


// sending query