Untitled

<?php

$hostname = "localhost";
$db_user = "swade_steven";
$db_password = "yeahman";
$db_table = "upstate_show";


$db = mysql_connect($hostname, $db_user, $db_password);
mysql_select_db("swade_information");
?>
<html>
<head>

<title>18th Annual Upstate High School Art Exhibit</title>
</head>
<body>
 <hr>
<?php
if (isset($_REQUEST['Submit']))
{
# THIS CODE TELL MYSQL TO INSERT THE DATA FROM THE FORM INTO YOUR MYSQL TABLE
$sql = "INSERT INTO $db_table(name,grade,homePhone,homeAddress,homeCity,homeState,homeZip,homeCounty,title,category,height,width,depth,media,schoolName,principal,instructor,schoolAddress,schoolCity,schoolState,schoolZip,schoolCounty,schoolPhone) values ('$name','$grade','$homePhone','$homeAddress','$homeCity','$homeState','$homeZip','$homeCounty','$title','$category','$height','$width','$depth','$media','$schoolName','$principal','$instructor','$schoolAddress','$schoolCity','$schoolState','$schoolZip','$schoolCounty','$schoolPhone')";
if($result = mysql_query($sql ,$db))
{
echo "Thank you for your entry";
}
else
{
echo "ERROR: ".mysql_error();
}

}
else
{
?>

<?php
}
?>
</body>
</html>