作者p3013220132 (小猪)
看板PHP
标题[请益] 不知道错再哪....麻烦看角@下
时间Tue Jul 24 15:48:42 2007
$insertSQL = sprintf("INSERT INTO member (username, password, name, sex, birthday, email, phone, address, uniform, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['username'], "text"),
GetSQLValueString($_POST['password'], "text"),
GetSQLValueString($_POST['name'], "text"),
GetSQLValueString($_POST['sex'], "text"),
GetSQLValueString($_POST['birthday'], "date"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['phone'], "text"),
GetSQLValueString($_POST['address'], "text"),
GetSQLValueString($_POST['uniform'], "text"),
GetSQLValueString($_POST['1'], "text"),
GetSQLValueString($_POST['2'], "text"),
GetSQLValueString($_POST['3'], "text"),
GetSQLValueString($_POST['4'], "text"),
GetSQLValueString($_POST['5'], "text"),
GetSQLValueString($_POST['6'], "text"),
GetSQLValueString($_POST['7'], "text"),
GetSQLValueString($_POST['8'], "text"),
GetSQLValueString($_POST['9'], "text"),
GetSQLValueString($_POST['10'], "text"));
错误讯息 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 '1, 2, 3, 4, 5, 6, 7, 8, 9, 10) VALUES ('12312312', '12312321', '
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 123.193.94.177