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')='Nov 2008'' at line 1<p>UPDATE ignore visitors SET visitors=visitors+1 WHERE memberid=68/ AND DATE_FORMAT(dateadded,'%b %Y')='Nov 2008'