You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' usedcredit=usedcredit+1 where bannerid=5935 and displaydate=CURDATE()' at line 1 update stats set numdisplay=numdisplay+1, gavecredit=gavecredit+, usedcredit=usedcredit+1 where bannerid=5935 and displaydate=CURDATE()