For Each

[corkg]

Hi

 

I need some help i need a peice of code to add the number indicated in the database when all items are "sold", all of the numbers are different.

 

This is the query:

 

$sellall=mysql_fetch_object(mysql_query("SELECT * FROM garage WHERE owner='$username'"));

 

how do i make it so it, updates the database.

 

mysql_query("UPDATE users SET money='$n_money' WHERE username='$username'");

 

But does this for each of the results in $sellall

 

Please Help

 

[darkfreaks]

Example code:

<?php
$rows= mysql_num_rows($sql);

if($row[garage]=="sold") { ("UPDATE users SET money='$n_money' WHERE username='$username'"); 

}else{ if($row[garage]!=="sold") { echo "Sorry but this garage is not sold yet!"; }



?>

[Fadion]

If im getting this right, DarkFreaks's code doesnt fully satisfy what u need. Try this:

 

$results = mysql_query("SELECT * FROM garage WHERE owner='$username'");
while($values = mysql_fetch_array($results)){
     if($values['item'] == 'sold'){ //or whatever it may be
          $resultsUpdate = mysql_query("UPDATE users SET money='$n_money' WHERE username='$username'");
     }
}