mysql - PHP SQL Query Fails to Execute -

<?php $db = new mysqli("localhost", "hidden", "hidden", "hidden"); if ($db->connect_error) {     die("failed connect."); } if (isset($_post["title"]) && isset($_post["description"]) && isset($_post["url"])) {     $title = $db->real_escape_string($_post["title"]);     $description = $db->real_escape_string($_post["description"]);     $url = $db->real_escape_string($_post["url"]);     $sql = "insert video (name, description, submission_date)     values ('{$title}', '{$description}', curdate());     insert video_source (video_id, url)     values (last_insert_id(), '{$url}');";     if ($db->query($sql) === true) {         echo "successfully added.";     } else {         echo "query failed.<br><br>data: {$title} {$description} {$url}";     } } else {     echo "data not set."; } $db->close();?> 

outputs "query failed." data entered. replacing variables such title constants still has same problem. tried query in phpmyadmin , worked fine (with constants).

it seems unhappy setting value of video_id.

anytime you're running multiple queries mysqli should use multi_query():

$db->multi_query($sql) 

in addition, last_insert_id() in second query not returning sort of value. if you're looking last inserted value of 1st query have return prior running second query.