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"; } }