我可以从MySQL数据库中选择，但是当我运行这个插入时没有任何反应（只插入1个表）

I am trying to insert into a table in my database, however nothing happens. Another script can write to a table, but when I run an insert query for any other table nothing happens, however I can run a fetch array query from any table. This is my code, which will not do anything, any ideas?

<?php
define("HOST", "localhost"); // The host you want to connect to.
define("USER", "*******"); // The database username.(Correct)
define("PASSWORD", "*******"); // The database password. (Correct)
define("DATABASE", "*******"); // The database name. (Correct)

$con = new mysqli(HOST, USER, PASSWORD, DATABASE);

$con->query("INSERT INTO Day (Order, Day,) VALUES ('7', 'Someday')");

mysqli_close($con);

?>

You have an extra comma in the below part after column Day:

$con->query("INSERT INTO Day (Order, Day,) VALUES ('7', 'Someday')");

Try to execute after removing it

mysqli has methods to retrieve errors, please check:

http://www.php.net/manual/de/mysqli.quickstart.statements.php

At first glance, you have a comma here "...Day , ) VALUES..." that shouldn't be there.

Regards,