语法错误或访问冲突：1064 SQL语法中有错误;

Question

I am getting some weird error with the following bit of code:

date_default_timezone_set('Europe/London');
            $date = date("Y-m-d H:i:s");    
            $stmt = $this->registry->db->getDB()->prepare("INSERT INTO `comments` (date_posted,comment) VALUES ?,?");
        $stmt->execute(array($date,$comment));

check the manual that corresponds to your MySQL server version for the right syntax to use near ''2015-04-27 15:26:31','Very good'' at line 1 in C:\wamp\www\model\qualityControlModel.class.php on line 161

Does anyone know why this is happening?

Answer 1

The correct syntax for the query line includes all of the parentheses, including those surrounding the VALUES:

$stmt = $this->registry->db->getDB()->prepare("INSERT INTO `comments` (date_posted,comment) VALUES (?,?)");