Untitled

<?php
if($_GET){
    $produce = $_GET['produce'];
    $state = $_GET['state'];
    $zip_code = $_GET['zip_code'];

$connect = mysql_connect("localhost", "user", "");
if(!$connect) {
} else {
    die('Failed to connect: ' . mysql_error());
}

if(!mysql_select_db("alica", $connect)){
    die('Failed to select DB: ' . mysql_error());
}
$result = mysql_query("SELECT * FROM alica");
while($row = mysql_fetch_array($result))
  {
  echo $row['Produce'] . " " . $row['State'];
  }
?>

<html>
<body>
<form action = "" method = "GET">
<b>Select your favorite fruit:</b><br/>
<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>
<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>
	<p>
<b>Enter your 5 digit zip code:</b><br/>
<input name="zip_code" maxlength="5" size="6" type="text" />
	<input type = "submit" value ="Search"/>
</form>
</body>
</html>