Query just errors all the time!

[thefollower]

I have a query which doesn't like the session im using for some reason not sure why though.. this is what i got :

 

$Update6 = "UPDATE restaurant SET RestaurantTotal = RestaurantTotal-$SellRestaurantStaff WHERE OwnerID='{$_SESSION['Current_User']}'";

 

When i put die($Update6);

I get:

UPDATE restaurant SET RestaurantTotal = RestaurantTotal-1 WHERE OwnerID='1'

 

Which is correct. And the query does work.. yet i then remove the die($Update6); and put:

$result6 = mysql_query($Update6) or die(mysql_error());

 

It doesn't like it and says:

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

 

What is up with that?! But the query still executes =/

[revraz]

Look at your quotes here

 

OwnerID='{$_SESSION['Current_User']}'

[thefollower]

I don't see whats wrong with that?

[thefollower]

I got this on a different script:

$UpdateMyMoney = "UPDATE userregistration SET MoneyInHand = MoneyInHand-$Price WHERE UserID= '{$_SESSION['Current_User']}'";
$moneyresult = mysql_query($UpdateMyMoney) or die(mysql_error());

 

 

And that works fine and i have the same session.. so how come it wont work for one but it will for another?