[Solved] MySQL INSERT statement brings an error [closed]

Question

Order is reserved word in MySQL, you can use back tick(`) around table name

Also you can use MySQL NOW() function for date instead of PHP variable $date

$t = "INSERT INTO `order` (order_date) VALUES (NOW())";

Accepted Answer

Order is reserved word in MySQL, you can use back tick(`) around table name

Also you can use MySQL NOW() function for date instead of PHP variable $date

$t = "INSERT INTO `order` (order_date) VALUES (NOW())";