jmberrueta Posted August 26, 2007 Share Posted August 26, 2007 Hi everyone. I hava a script that needs to update a value in a database (let's say, for example, add 1 to the value of a field). So, I first need to read the value in that fileld, increase it, and update the field. In the meantime, such script may be called by another user. Is that posible? If so, the read value might change before the field update is done... How can that be solved? Is there any php/mysql blocking for that? Thanks in advance Quote Link to comment https://forums.phpfreaks.com/topic/66773-solved-mysql-concurrence/ Share on other sites More sharing options...
teng84 Posted August 26, 2007 Share Posted August 26, 2007 yup! update add one then do something like this update table set field=field+1 where etc.... Quote Link to comment https://forums.phpfreaks.com/topic/66773-solved-mysql-concurrence/#findComment-334737 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.