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