Based on:

I came up with this, but no joy:

PHP Code:
$cliorder_clear "ABC";
          UPDATE plan SET curacc = curacc + 1 WHERE cliorder = '" 
$cliorder_clear "' COMMIT";
mysql_query(" . $query . ") or die(mysql_error()); 
What needs to be changed?

ERROR PRODUCED: 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 '. START TRANSACTION WORK UPDATE plan SET curacc = curacc + 1 WHERE cl' at line 1