Hey, könnt ihr mir evtl. sagen was an dieser Query falsch ist?
PHP sagt mir diesen Error:
PHP Code:
$statement = $pdo->prepare("INSERT INTO ticketsystem.tickets(ticketid, reporter, reportdate, lastreplier, title, message) VAUES (?, ?, ?, ?, ?, ?)");
$statement->execute(array($result[0]+1, $reporter, date('Y-m-d H:i:s'), 'customer', $title. $description));
Quote:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'VAUES ('1', 'test', '2013-01-01', 'test', 'testtitel', 'test')' at line 1' in /var/www/ticketsystem/pages/newTicket.php:25 Stack trace: #0 /var/www/ticketsystem/pages/newTicket.php(25): PDOStatement->execute(Array) #1 /var/www/ticketsystem/pages/contentLoader.php(7): include('/var/www/ticket...') #2 /var/www/ticketsystem/frontend/main.php(28): include('/var/www/ticket...') #3 /var/www/ticketsystem/index.php(7): include('/var/www/ticket...') #4 {main} thrown in /var/www/ticketsystem/pages/newTicket.php on line 25