[Resolved] IF statement and LIST

[kickme21]

I have three options on my list box. I am updating Mysql database but I don't want to update it if it goes above a value (the value is in anouther table). The prob is the new value will be different depending on what is selected so it will need to compair the new value.

I have put

if ($select == "100"){
$newpitmen = $oldpitmen + 1;
$new = $oldturns - $select;
$newmoney = $oldmoney - $select;
}
if ($select == "200"){
$newpitmen = $oldpitmen + 2;
$new = $oldturns - $select;
$newmoney = $oldmoney - $select;
}
if ($select == "300"){
$newpitmen = $oldpitmen +3;
$new = $oldturns - $select;
$newmoney = $oldmoney - $select;
$newpitmen >= $max;
echo "Sorry you cannot Recuite anymore";
}
mysql_query("UPDATE users SET pitmen = '$newpitmen' WHERE username='$user'",$link);
mysql_query("UPDATE users SET people = '$new' WHERE username='$user'",$link);
mysql_query("UPDATE users SET money = '$newmoney' WHERE username='$user'",$link);

Thanks

[Weedpacket]

if($newpitmen<$whatever_the_maximum_is)
mysql_query("UPDATE ....");
Ditto for the other fields.

Or, smarter, would be to write just one query to update all three fields simultaneously. Build the start of the query, use the if statements to attach the appropriate updates if they're valid, and then tack the WHERE clause on the end.

[kickme21]

yes I had a look around and I have totaly re-written the script and i all works ok now thanks