[SOLVED] wrong result from UPDATE query.

[MasterACE14]

I have this basic UPDATE query...

UPDATE `UserDetails` SET `gold`=`gold`+((`untrainedSold`*10)+(`miners`*25))

 

untrainedSold has the value 181

 

and miners is 3,593

 

The value I am expecting to be added to gold from this query is 91,635

 

but its currently adding around 7 million.

 

Any ideas why?

[PFMaBiSmAd]

Try the following to see what it evaluates to -

 

SELECT ((`untrainedSold`*10)+(`miners`*25))

 

If that value is correct, then your query is probably being executed multiple times.

[MasterACE14]

when I run that, the value is correct. how do I determine whether the query is being executed multiple times?

[PFMaBiSmAd]

Use a session with a counter in it or use the php error_log() function to write information about your queries to a log file. The mysql built-in query log also shows the date/time, mysql user, and the actual query.

[MasterACE14]

I found the problem. the query was within a large 'for' loop which covered most of the file.

 

Thanks for your help PFMaBiSmAd 

 

much appreciated!

 

Regards ACE