不好意思,我简单点
部分PHP代码如下:
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
...
$insertSQL="
set @eventID := (SELECT event_id FROM event WHERE event_id IS NULL);
set @leaderID := (SELECT leader_id FROM leader WHERE leader_name=".$leader_name.");
INSERT INTO event_leader (event_id, leader_id) values(@eventID,@leaderID)"; mysql_select_db($database_mconn, $mconn);
$Result1 = mysql_query($insertSQL, $mconn) or die(mysql_error());
}下面是错误输出:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; set @leaderID := (SELECT leader_id FROM leader WHERE leader
到底错在哪????
用echo $insertSQL查询得:
set @eventID := (SELECT event_id FROM event WHERE event_id IS NULL); set @leaderID := (SELECT leader_id FROM leader WHERE leader_name='LO'); INSERT INTO event_leader (event_id, leader_id) values(@eventID,@leaderID)
部分PHP代码如下:
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
...
$insertSQL="
set @eventID := (SELECT event_id FROM event WHERE event_id IS NULL);
set @leaderID := (SELECT leader_id FROM leader WHERE leader_name=".$leader_name.");
INSERT INTO event_leader (event_id, leader_id) values(@eventID,@leaderID)"; mysql_select_db($database_mconn, $mconn);
$Result1 = mysql_query($insertSQL, $mconn) or die(mysql_error());
}下面是错误输出:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; set @leaderID := (SELECT leader_id FROM leader WHERE leader
到底错在哪????
用echo $insertSQL查询得:
set @eventID := (SELECT event_id FROM event WHERE event_id IS NULL); set @leaderID := (SELECT leader_id FROM leader WHERE leader_name='LO'); INSERT INTO event_leader (event_id, leader_id) values(@eventID,@leaderID)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货