odbc sql statement


odbc sql statement

有人能告诉我这句话怎么了吗?

$sql = "INSERT INTO FK_Kunde(Anschrift_Vorname) VALUES('".$_POST['vorname']."') WHERE Anschrift_Vorname = 'Petra'";

错误消息:

Warning: odbc_exec(): SQL error: [SAP][ODBC Driver][SQL Anywhere]Syntaxfehler bei 'WHERE' in Zeile 1, SQL state 37000 in SQLExecDirect in C:'xampp'htdocs'php2lex'write2Odbc.php on line 16
shit happens [SAP][ODBC Driver][SQL Anywhere]Syntaxfehler bei 'WHERE' in Zeile 1

没有像insert into这样的语法。。。价值观其中-我想你需要一份更新声明。

$sql = "Update FK_Kunde set Anschrift_Vorname = '".$_POST['vorname']."' WHERE Anschrift_Vorname = 'Petra'";

此外,您还应该了解准备好的语句,以防止SQL注入。