The standard MySQL library can only have one statement at a time. You're trying to use four UPDATE statements with a single call to mysql_query. In this case, you can manipulate the query (the WHERE clause) into just one statement since all of the rows to be updated will be given the same new date value.