//Set the variables for the database access: $host = "mysql12.powweb.com"; $username="db301user"; $password="hop3ful"; $database="apptSet301"; mysql_connect($host,$username,$password,$database); $first=$_POST['fname']; $last=$_POST['lname']; $company=$_POST['company']; $address=$_POST['address']; $floor=$_POST['floor']; $suite=$_POST['suite']; $city=$_POST['city']; $phone=$_POST['phone']; $day=$_POST['day']; $dropOffTime=$_POST['dropOffTime']; $pickUpTime=$_POST['pickUpTime']; $service1=$_POST['service1']; $service2=$_POST['service2']; $service3=$_POST['service3']; $service4=$_POST['service4']; @mysql_select_db($database) or die( "Unable to select database"); $query = "INSERT INTO appointments VALUES ('$first','$last','$company','$address','$suite','$floor','$city', '$phone', '$day', '$dropOffTime', '$pickUpTime', '$service1', '$service2', '$service3', '$service4'"; mysql_query($query); mysql_close(); ?>