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 'AND DATE_FORMAT(dateadded,'%b %Y')='Jul 2010'' at line 1<p>UPDATE ignore visitors SET visitors=visitors+1 WHERE memberid=3863&tid= AND DATE_FORMAT(dateadded,'%b %Y')='Jul 2010'