mysql 语法错误检查,php – MySQL错误:“SQL语法错误;检查与您的MySQL服务器版本对应的手册,以获得正确的语法“...

我从MySQL得到这个错误:

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 'Details

(title, first, last, NRIC, po' at line 1

这是代码:

$link = mysql_connect("localhost", "root", "");

if (!$link) { die('Could not connect: ' . mysql_error()); }

$db_selected = mysql_select_db(Membership, $link);

if (!$db_selected) { die('Can\'t use' . Membership . ':' . mysql_error()); }

$value1 = $_POST["title"];

$value2 = $_POST["first"];

$value3 = $_POST["last"];

$value4 = $_POST["NRIC"];

$value5 = $_POST["birthdate"];

$value6 = $_POST["birthmonth"];

$value7 = $_POST["birthyear"];

$value8 = $_POST["address"];

$value9 = $_POST["postal"];

$value10 = $_POST["genderSelect"];

$value11 = $_POST["contact"];

$value12 = $_POST["email"];

$value13 = $_POST["enter"];

$value14 = $_POST["password"];

$value15 = $_POST["Updates"];

$value16 = $_POST["Terms"];

$value17 = $_POST["submit_but"];

$value18 = $_POST["status"];

$sql = "INSERT INTO Member Details (title, first, last, NRIC, birthdate, birthmonth, birthyear, address, postal, genderSelect, contact, email, enter, password, Updates, Terms, submit_but, status) VALUES ('$value', '$value2', '$value3', '$value4', '$value5', '$value6', '$value7', '$value8', '$value9', '$value10', '$value11', '$value12', '$value13', '$value14', '$value15', '$value16', '$value17', '$value18')";

if (!mysql_query($sql)){ //The error is thrown here

die('Error: ' . mysql_error());

}

mysql_close();

?>

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值