you know what is wrong with this query? I echo and query… I use PHP PDO
time() save in mysql what type must be the db field…?
INSERT INTO table('username', 'carid', 'tries', 'time_retry', 'IP', 'sys_update_date') VALUES ('yyy', 123456, 5, 1491378965, '38.34.44.255', '2017-04-04 17:56:05')
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 ''username', 'carid', 'tries', 'time_retry' 'IP', 'sys_update_date') VALUES ('tes' at line 1
table is a reserved word. If you’re going to use a reserved word as a name (which is a bad idea, almost 100% of the time), you’ve got to surround it in quotes.
It could be what you’re using for the single quote.
` (to the left of the 1 on the US QWERTY keyboard) is not the same as ’ (under the double quote symbol on the US QWERTY keyboard). One works in mySQL, one doesn’t,