herghost Posted November 3, 2009 Share Posted November 3, 2009 Hi all, I am having a problem with the below: $remove = "SELECT credits FROM users_details WHERE credits > 9"; $result=mysql_query($remove) or die ("shit " .mysql_error()) ; $rows = mysql_fetch_array($result); $credits = $rows['credits']; $m = 10; if ($credits > 9) { $nc = $credits - $m; $updatec = "UPDATE users_details SET credits=$nc"; if (mysql_query($updatec)) { echo "Credits Removed<br />\n"; } else { die(mysql_error()); } } Basically it is meant to remove 10 credits from any user that has above 10 credits. However instead it find the 1st user with more than 10, ie this user has 20 credits, it then changes every user with above 10 credits to only having 10 credits, regardless if the have 40 or 2000! How do I get around this? Thanks Link to comment https://forums.phpfreaks.com/topic/180094-solved-more-phpmysql-woes/ Share on other sites More sharing options...
JonnoTheDev Posted November 3, 2009 Share Posted November 3, 2009 Basically it is meant to remove 10 credits from any user that has above 10 credits This will update all records greater than 10 credits in one go. You do not require any loop (this is your current error, there is no loop. Only one record returned)! UPDATE users_details SET credits = credits-10 WHERE credits > 10 Link to comment https://forums.phpfreaks.com/topic/180094-solved-more-phpmysql-woes/#findComment-950073 Share on other sites More sharing options...
herghost Posted November 3, 2009 Author Share Posted November 3, 2009 ahh, Thanks Link to comment https://forums.phpfreaks.com/topic/180094-solved-more-phpmysql-woes/#findComment-950078 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.