[SOLVED] more php/mysql woes

[herghost]

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

[JonnoTheDev]

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

[herghost]

ahh,

 

Thanks