if ($sql_num_row != 0) { if ($o_potion != "0") { $qupdate = "UPDATE aps SET `$o_potion` = `{$o_potion}_num` WHERE player = '$o_name'"; $update_res = mysql_query($qupdate) or die ("Query failed: " . mysql_error()); echo "Update Potion for $o_name"; } if ($o_joiner != "0") { $qupdate = "UPDATE aps SET `$o_joiner` = `{$o_joiner}_num` WHERE player = '$o_name'"; $update_res = mysql_query($qupdate) or die ("Query failed: " . mysql_error()); echo "Update Raid for $o_name"; } if ($o_spotter != "0") { $qupdate = "UPDATE aps SET `$o_spotter` = `$o_spotter` + 1 WHERE player = '$o_name'"; $update_res = mysql_query($qupdate) or die ("Query failed: " . mysql_error()); echo "Update Raid for $o_name"; } }