mysql insert 多表,多次运行MySQL INSERT查询（将值插入到多个表中）

basically, I have 3 tables; users and projects, then I have 'users_projects' to allow the one-to-many formation. When a user adds a project, I need the project information stored and then the 'userid' and 'projectid' stored in the usersprojects table. It sounds like its really straight forward but I'm having problems with the syntax I think!?

As it stands, I have this as my INSERT queries (values going into 2 different tables):

$projectid = $_POST['projectid'];

$pname = $_POST['pname'];

$pdeadline = $_POST['pdeadline'];

$pdetails = $_POST['pdetails'];

$userid = $_POST['userid'];

$sql = "INSERT INTO projects (projectid, pname, pdeadline, pdetails) VALUES

('{$projectid}','{$pname}','{$pdeadline}','{$pdetails}')";

$sql = "INSERT INTO users_projects (userid, projectid) VALUES

('{$userid}','{$projectid}')";

$result = mysql_query($sql, $connection)

or die("MySQL Error: ".mysql_error());

header("Location: frontview.php");

exit();

解决方案

You simply forgot to execute the sql between each query. Add the

mysql_query($sql, $connection)

or die("MySQL Error: ".mysql_error());

between each query and you are supposed to be fine.

b.t.w (1) it always helpful to test with a console open with tail -f on the sql log (under /var/log/mysql/ )

b.t.w.(2) You are having heavy security issues in your code.

b.t.w (3) You might want to consider using PDO/Mysqli and not the old mysql extension.

b.t.w (4) It would make your life simpler to use some kind of wrapper (a good class) to approach the DB and not do it directly everywhere in your code.