Based on: http://dev.mysql.com/doc/refman/5.0/en/commit.html

I came up with this, but no joy:

PHP Code:
$cliorder_clear "ABC";
$query "START TRANSACTION WORK
          UPDATE plan SET curacc = curacc + 1 WHERE cliorder = '" 
$cliorder_clear "' COMMIT";
include 
"connect_to_mysql.php";  
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