This only inputs form data into the users table, not sure what I'm missing but I need it to put data in all the tables.
<?php
define('DB_NAME' , '');
define('DB_USER' , '');
define('DB_PASSWORD' , '');
define('DB_HOST' , '');
$link = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD);
if (!$link) {
die ('Could not connect'. mysql_error());
}
$db_selected = mysql_select_db(DB_NAME, $link);
if (!$db_selected) {
die ('Can’t use' . DB_NAME . ':' . mysql_error ());
}
$value = $_POST['lastname'];
$value2 = $_POST['firstname'];
$value3 = $_POST['middlename'];
$value4 = $_POST['address'];
$value5 = $_POST['city'];
$value6 = $_POST['state'];
$value7 = $_POST['zipcode'];
$value8 = $_POST['phonenumber'];
$value9 = $_POST['emailaddress'];
$value10 = $_POST['vin'];
$value11 = $_POST['auto'];
$value12 = $_POST['DMV'];
$value13 = $_POST['type'];
$value14 = $_POST['firstchoice'];
$value15 = $_POST['firstchoicemeaning'];
$value16 = $_POST['secondchoice'];
$value17 = $_POST['secondchoicemeaning'];
$value18 = $_POST['thirdchoice'];
$value19 = $_POST['thirdchoicemeaning'];
$value20 = $_POST['giftlastname'];
$value21 = $_POST['giftfirstname'];
$value22 = $_POST['giftmiddlename'];
$sql = "INSERT INTO Users (lastname, firstname, middlename, address, city, state, zipcode, phonenumber, emailaddress) VALUES ('$value', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9')";
mysql_query($sql)
$sql = "INSERT INTO Vehicle (vin, auto) VALUES ('$value10', '$value11')";
mysql_query($sql1)
$sql = "INSERT INTO Licence Plate (DMV, type, firstchoice, firstchoicemeaning, secondchoice, secondchoicemeaning, thirdchoice, thirdchoicemeaning) VALUES ('$value12', '$value13', '$value14', '$value15', '$value16', '$value17', '$value18', '$value19')";
mysql_query($sql2)
$sql = "INSERT INTO Gift (giftlastname, giftfirstname, giftmiddlename) VALUES ('$value20', '$value21', '$value22')";
mysql_query($sql3)
mysql_close();
