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 'WHERE OwnerID='1'' at line 1
Yet when i echo'd it.. it looked fine so i dont get why it wont work.
$Update = "UPDATE restaurant SET TableStaffTotal = TableStaffTotal-$SellTableStaff WHERE OwnerID='{$_SESSION['Current_User']}'";
$result = mysql_query($Update) or die(mysql_error());
What is wrong exactly ? Cos the OwnerID='{$_SESSION['Current_User']} I have used many times before and its only just now not allowed it =/
The query itself looks fine. If you're quoting the query in single quotes though, the quotes around your Owner ID are going to cause problems. Wrap your query in double-quotes & it should work.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
UPDATE restaurant SET TableStaffTotal = TableStaffTotal-1 WHERE OwnerID='1'
I did ^ that is the echo it gave me.
The the next question would be are the names of the TableStaffTotal and OwnerID correct. And perhaps you cannot do numeric operations on TableStaffTotal.