Ok, I have been trying to get my if statements to work and they don't, well they do and don't I should say. Here is the code below. The portion of the code I am working on is
if ($red == "1" && $red_2 == "6" && $lton > $lton_2) {$goals = "50";}
if ($red == "1" && $red_2 == "9" && $hattrk > $hattrk_2) {$saves = "50";}
The problem is that goals will update but when it gets to saves it won't. Any help is appreciated, and thanks for the help in advance.
<?php
if($hand == '2') {
$t1_name = stripslashes($t1_name);
$t2_name = stripslashes($t2_name);
if($selectteam == "all") {
$result_pi = mysql_query("SELECT * FROM ".$_CONF['tprefix']."players WHERE (teamid = '$gm_team1') AND registered = '1'");
$result_pi_2 = mysql_query("SELECT * FROM ".$_CONF['tprefix']."players WHERE (teamid = '$gm_team2') AND registered = '1'");
} else {
$result_pi = mysql_query("SELECT * FROM ".$_CONF['tprefix']."players WHERE teamid = '$selectteam' AND registered = '1'");
}
$total_pi = mysql_numrows($result_pi);
$total_pi_2 = mysql_numrows($result_pi_2);
$i = 0;
$stats = "
<br>
<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"100%\">
<tr bgcolor=\"#999999\" align=\"center\">
<td class=\"table_header\" colspan=9>$_LANG[admin_home]: $t1_name</td>
<td bgcolor=\"#ffffff\"></td>
<td class=\"table_header\" colspan=9>$_LANG[admin_visitor]: $t2_name</td>
</tr>
<tr bgcolor=\"#999999\" align=\"center\">
<td class=\"table_header\">Name</td>
<td class=\"table_header\">1</td>
<td class=\"table_header\">2</td>
<td class=\"table_header\">3</td>
<td class=\"table_header\">4</td>
<td class=\"table_header\">T</td>
<td bgcolor='#FFFFFF'></td>
<td class=\"table_header\">Name</td>
<td class=\"table_header\">1</td>
<td class=\"table_header\">2</td>
<td class=\"table_header\">3</td>
<td class=\"table_header\">4</td>
<td class=\"table_header\">T</td>
</tr>
";
}
while($i < $total_pi OR $i < $total_pi_2) {
$tbgcolor = is_int($i / 2)?"#cccccc":"#ffffff";
$pid = mysql_result($result_pi,$i,"id");
$pid_2 = mysql_result($result_pi_2,$i,"id");
$pteam_id = mysql_result($result_pi,$i,"teamid");
$pteam_id_2 = mysql_result($result_pi_2,$i,"teamid");
$result_t = mysql_query("SELECT name FROM ".$_CONF['tprefix']."teams WHERE id = '$pteam_id'");
$playerteam = mysql_result($result_t,0,"name");
$result_t_2 = mysql_query("SELECT name FROM ".$_CONF['tprefix']."teams WHERE id = '$pteam_id_2'");
$playerteam_2 = mysql_result($result_t_2,0,"name");
$result_ps = mysql_query("SELECT * FROM ".$_CONF['tprefix']."player_stats WHERE playerid = '$pid' AND game_id = '$_GET[id]'");
$total_ps = mysql_numrows($result_ps);
$result_ps_2 = mysql_query("SELECT * FROM ".$_CONF['tprefix']."player_stats WHERE playerid = '$pid_2' AND game_id = '$_GET[id]'");
$total_ps_2 = mysql_numrows($result_ps_2);
if($total_ps != 0 OR $total_ps_2 != 0) {
$played = mysql_result($result_ps,0,"played");
$played_2 = mysql_result($result_ps_2,0,"played");
$red = mysql_result($result_ps,0,"red");
$goals = mysql_result($result_ps,0,"goals");
$goals_2 = mysql_result($result_ps_2,0,"goals");
$saves = mysql_result($result_ps,0,"saves");
$saves_2 = mysql_result($result_ps_2,0,"saves");
$red_2 = mysql_result($result_ps_2,0,"red");
$lton = mysql_result($result_ps,0,"lton");
$lton_2 = mysql_result($result_ps_2,0,"lton");
$hton = mysql_result($result_ps,0,"hton");
$hton_2 = mysql_result($result_ps_2,0,"hton");
$hattrk = mysql_result($result_ps,0,"hattrk");
$hattrk_2 = mysql_result($result_ps_2,0,"hattrk");
$fivmrk = mysql_result($result_ps,0,"fivmrk");
$fivmrk_2 = mysql_result($result_ps_2,0,"fivmrk");
$team_id = mysql_result($result_ps,0,"team_id");
$team_id_2 = mysql_result($result_ps_2,0,"team_id");
} else {
$played = "0";
$played_2 = "0";
$goals = "";
$goals_2 = "";
$saves = "";
$saves_2 = "";
$red = "";
$red_2 = "";
$lton = "";
$lton_2 = "";
$hton = "";
$hton_2 = "";
$hattrk = "";
$hattrk_2 = "";
$fivmrk = "";
$fivmrk_2 = "";
}
if($played == 1) {$played_checked = " checked";}
else {$played_checked = "";}
if($played_2 == 1) {$played_checked_2 = " checked";}
else {$played_checked_2 = "";}
if($handi == '2') {
$stats .= "<tr bgcolor=\"".$tbgcolor."\" align=\"center\">";
$pos_array = array( 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5');
$stats .= "<td><select class='table_text' name='red[".$pid."]' style='width:40;'>";
$stats .= "<option value=\"0\"$selected></option>";
for($pos_count=1; $pos_count <= count($pos_array); $pos_count++) {
$selected = ($pos_array[$pos_count] == $red)?" selected":"";
$stats .= "<option value=\"$pos_count\"$selected>{$pos_array[$pos_count]}</option>";
}
if ($red == "1" && $red_2 == "6" && $lton > $lton_2) {$goals = "50";}
if ($red == "1" && $red_2 == "9" && $hattrk > $hattrk_2) {$saves = "50";}
$stats .= "</select></td>
<td class=\"table_text\"><b>".mysql_result($result_pi,$i,"fname")." ".mysql_result($result_pi,$i,"lname")."</b> $playred</td>
<td class=\"table_text\"><input type=\"checkbox\" name=\"played[".$pid."]\" value=\"1\"".$played_checked."></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"lton[".$pid."]\" value=\"".$lton."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"hton[".$pid."]\" value=\"".$hton."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"hattrk[".$pid."]\" value=\"".$hattrk."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"fivmrk[".$pid."]\" value=\"".$fivmrk."\" maxlength=\"4\"></td>
<input type=\"hidden\" name=\"goals[".$pid."]\" value=\"".$goals."\">
<input type=\"hidden\" name=\"saves[".$pid."]\" value=\"".$saves."\">
<input type=\"hidden\" name=\"team_id[".$pid."]\" value=\"".$pteam_id."\">
<td style='background:#ffffff;'></td>";
$pos_array_2 = array( 1 => '1', 2 => '2', 3 => '3', 4 => '4', 5 => '5', 6 => '6', 7 => '7', 8 => '8', 9 => '9', 10 => '10');
$stats .= "<td><select name='red[".$pid_2."]' style='width:40;'>";
$stats .= "<option value=\"0\"$selected></option>";
for($pos_count_2=6; $pos_count_2 <= count($pos_array_2); $pos_count_2++) {
$selected = ($pos_array_2[$pos_count_2] == $red_2)?" selected":"";
$stats .= "<option value=\"$pos_count_2\"$selected>{$pos_array_2[$pos_count_2]}</option>";
}
$stats .= "</select></td>
<td class=\"table_text\"><b>".mysql_result($result_pi_2,$i,"fname")." ".mysql_result($result_pi_2,$i,"lname")."</b></td>
<td class=\"table_text\"><input type=\"checkbox\" name=\"played[".$pid_2."]\" value=\"1\"".$played_checked_2."></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"lton[".$pid_2."]\" size=\"1\" value=\"".$lton_2."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"hton[".$pid_2."]\" size=\"1\" value=\"".$hton_2."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"hattrk[".$pid_2."]\" size=\"1\" value=\"".$hattrk_2."\" maxlength=\"4\"></td>
<td class=\"table_text\"><input class='ps' type=\"text\" name=\"fivmrk[".$pid_2."]\" size=\"1\" value=\"".$fivmrk_2."\" maxlength=\"4\"></td>
<input type=\"hidden\" name=\"team_id[".$pid_2."]\" value=\"".$pteam_id_2."\">
</tr>";
$i++;
unset($result_ps);
}
}
?>
