<form method="post" action="index.php">
Vintage:
</br><input type="textbox" name="vin" maxlength="4"></br>
Winery:
</br><input type="textbox" name="winery"></br>
Varietal:
</br><input type="textbox" name="varietal"></br>
AVA:
</br><input type="textbox" name="ava"></br>
Case:
</br><input type="textbox" name="cases"></br>
Description:
</br><textarea rows="5" cols="40" name="descrip"></textarea></br>
Price:
</br><input type="textbox" name="price" maxlength="2"></br>
Score:
</br><input type="textbox" name="score" maxlength="3"></br>
Recomendation:<br>
Yes
</br><input type="radio" name="rec" value="yes"></br>
No
</br><input type="radio" name="rec" value="no"></br>



</br><input type="submit" value="Send">
</form>


<?php
$dbuser = 'ross';
$dbpassword = 'password';
$dbserver = 'localhost';
$dbdb = 'wine';

$con = mysql_connect($dbserver,$dbuser,$dbpassword);
mysql_connect($dbserver,$dbuser,$dbpassword) or die(mysql_error());
mysql_select_db($dbdb, $con) or die(mysql_error());



if ($_SERVER['REQUEST_METHOD'] == "POST") {
$vin = $_POST['vin'];
$winery = $_POST['winery'];
$varietal = $_POST['varietal'];
$ava = $_POST['ava'];
$cases = $_POST['cases'];
$descrip = $_POST['descrip'];
$price = $_POST['price'];
$score = $_POST['score'];
$rec = $_POST['rec'];
mysql_query("INSERT INTO winelist (vin, winery, varietal, ava, case, descrip, price, score, rec)
VALUES ('$vin', '$winery', '$varietal', '$ava', '$cases', '$descrip', '$price', '$score', '$rec')");

echo 'Successfully Added';
}




?>