connect_errno) {
echo "db connection error : " . $mysql->connect_error;
exit();
}
$sql = "
INSERT INTO dvd_titles
(title, release_date, award, label_id,
sound_id, genre_id, rating_id, format_id)
VALUES
(" .
"'" . $_REQUEST["title"] . "'," .
"'" . $_REQUEST["release_date"] . "'," .
"'" . $_REQUEST["award"] . "'," .
$_REQUEST["label"] .
"," .
$_REQUEST["sound"] .
"," .
$_REQUEST["genre"] .
"," .
$_REQUEST["rating"] .
"," .
$_REQUEST["format"] .
")";
echo "
$sql
";
//exit();
$results = $mysql->query($sql);
if(!$results) {
echo "ERROR, PROBLEM!!!";
echo "
SQL:" . $sql;
echo "
Error from db: " . $mysql->error;
exit(); // stop page
}
$newid = $mysql->insert_id;
echo "
movie added, new record ID is $newid";