Menu
I can not for the life of me find out what is wrong with this query:
UPDATE Fees_1 SET category=’Facilities’, desc=’This is an invoice’, due=200.00, date=’ASDASD’ WHERE invoice=1
It must be simple but I’m just not seeing it. The error message i keep getting is:
Query failed: 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 ‘desc=’This is an invoice’, due=200.00, date=’ASDASD’ WHERE invoice=1′ at line 1
I’ve triple checked my syntax and I haven’t a clue what its being pissy about.