[請益] 不知道錯再哪....麻煩看角@下

看板PHP作者 (小豬)時間18年前 (2007/07/24 15:48), 編輯推噓0(000)
留言0則, 0人參與, 最新討論串1/2 (看更多)
$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
文章代碼(AID): #16fQxRh9 (PHP)
文章代碼(AID): #16fQxRh9 (PHP)