I’m experiencing some weird behaviour with inserting a single field to a mysql database.
The query itself is
$unix = time();
mysql_query("INSERT INTO db_ord (sub, order_date, type, request_date) VALUES (0, 0, 0, $unix)");
No errors but it just won’t insert anything into the database. Although if I call msyql_insert_id(); right after it, it does return the newly-generated id, which increases with each execution.
I guess the weirdest part is that if I make a copy of this query and put it right after this one then the first query works.
And if I make a new .php file with only one query in it and run it, then it works again.
So I’m hoping some of you have come across something like this and can help me because I can’t imagine what could be causing this