Monkuar Posted March 2, 2009 Share Posted March 2, 2009 "UPDATE ibf_members SET friendcount=friendcount -1 WHERE id = '" . $this->member['id'] . "'" Sometimes it works and sometimes it doesn't Can somone give me the same qeury but different so it add's +1 to the variable friendcount each time it is runned, thanks! Quote Link to comment https://forums.phpfreaks.com/topic/147522-is-there-something-wrong-with-my-query/ Share on other sites More sharing options...
ratcateme Posted March 2, 2009 Share Posted March 2, 2009 to get it to add one just change the -1 to a +1 the query looks fine to me. if you say it works and some times it doesn't. can you tell us how it doesn't work? Scott. Quote Link to comment https://forums.phpfreaks.com/topic/147522-is-there-something-wrong-with-my-query/#findComment-774412 Share on other sites More sharing options...
Monkuar Posted March 2, 2009 Author Share Posted March 2, 2009 like i know the +1 and -1 but how can i simplify it so it's better because only it works add the +1 and when i do the delete one it sometimes does the -1... weird man im french sorry for english.. omg Quote Link to comment https://forums.phpfreaks.com/topic/147522-is-there-something-wrong-with-my-query/#findComment-774413 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.