[SOLVED] division in an update...

[thefollower]

I have a query with a division in it but i don't know if the syntax is wrong.. no errors occur but it doesn't appear to work either:

does it look right?

 

mysql_query("UPDATE tablename SET CurrentLife=CurrentLife/2 WHERE UserID='$DefenderID'")
or die(mysql_error());

 

[Psycho]

but it doesn't appear to work either

 

And, what does it "appear" to do?

 

I woud suggest putting the division within parens:

 

UPDATE tablename SET CurrentLife=(CurrentLife/2) WHERE UserID='$DefenderID'

[Barand]

Syntax ok, echo $DefenderID to ensure its value is correct

[thefollower]

DefenderID echo's correctly. But now i know the sytnax works that means my if statement structure is not correct!

 

Thanks for the help guys!