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);
?>