编辑:阅读下面的答案,然后阅读我不正确的SQL知识大声笑
所以我试图插入一个变量,由于某种原因,它认为它是一列,即使我用单引号引起来也是如此。我究竟做错了什么?谢谢你的时间。
Unknown column '$emailAddress' in 'field list'] in EXECUTE("UPDATE mailer_recipients SET email_address=$emailAddress WHERE id=539")
$sql = 'UPDATE ' . $this->recipientDbTable . ' SET ' . $this->recipientDbColumn['result_id'] . '=' . '$hash' . ' WHERE ' . $this->recipientDbColumn['id'] . '=' . $this->emailId;
$sql = 'UPDATE ' . $this->recipientDbTable . ' SET ' . $this->recipientDbColumn['address'] . '=' . '$emailAddress' . ' WHERE ' . $this->recipientDbColumn['id'] . '=' . $this->emailId;
尝试这个:
$sql = "UPDATE {$this->recipientDbTable} SET {$this->recipientDbColumn['result_id']} = '{$hash}' WHERE {$this->recipientDbColumn['id']} = {$this->emailId}";
阅读单引号和双引号之间的区别。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句