First START TRANSACTION

Databases
1

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

I came up with this, but no joy:


$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