mysql_query("INSERT INTO accounting(transid, unixtime, username, description, amount, type, time) VALUES('$randomtransid', '0', '$yti', 'BLVD Offer Completion', '$theamount', 'points', '$dateandtime')");
The example code above is my MySQL query but it does not get added into the MySQL database every time I refresh the page...
What can I do?
============= SOLVED:
After adding "mysql_error();",
this is the error:
Query failed: Duplicate entry ... for key 'uniqueness'
I fixed this by changing the structure of my database table.
Thanks
=============