Loading...
Помощь по скриптам | Помогите с подсчетом из цикла))
Есть следующий код:
php
   $sql = $db ->query("SELECT * FROM `games` WHERE `team_1` = '".$game['team_1']."' AND `team_2` = '".$game['team_2']."' AND `status` = '1' AND LENGTH(score) < '9' OR `team_1` = '".$game['team_2']."' AND `team_2` = '".$game['team_1']."' AND `status` = '1' AND LENGTH(score) < '9' ORDER BY `id` DESC LIMIT 5");  $gols_1 = 0; $gols_2 = 0; $win_1 = 0; $win_2 = 0; $draw = 0;  while($history = $sql->fetch_assoc()){  $score  = $history['score']; $scores = explode("-", $score);  if($scores['0'] == $scores['1']){ $draw++;  if($history['team_1'] = $game['team_1']){ $gols_1+$scores['0']; } else if($history['team_1'] = $game['team_2']){ $gols_2+$scores['0']; } else if($history['team_2'] = $game['team_1']){ $gols_1+$scores['1']; } else if($history['team_2'] = $game['team_2']){ $gols_2+$scores['1']; }  }//draw  else if($scores['0'] > $scores['1']){  if($history['team_1'] = $game['team_1']){ $win_1++; $gols_1+$scores['0']; }  else if($history['team_1'] = $game['team_2']){ $win_2++; $gols_2+$scores['0']; }  }//win $history['team_1']   else if($scores['0'] < $scores['1']){  if($history['team_2'] = $game['team_1']){ $win_1++; $gols_1+$scores['1']; }  else if($history['team_2'] = $game['team_2']){ $win_2++; $gols_2+$scores['1']; }  }//win $history['team_2']  }//while   
Но в переменные не записываются данные(( Может чего не вижу... Спасибо за внимание!
________
посл. ред. 08.02.2021 в 17:03; всего 1 раз(а); by 255523536
$gols_1+$scores['0']; комбинированный оператор присваивания с арифметическим действием применяется так
php
   $gols_1 += $scores['0'];   
php
   $sql = $db ->query("SELECT * FROM `games` WHERE `team_1` = '".$game['team_1']."' AND `team_2` = '".$game['team_2']."' AND `status` = '1' AND LENGTH(score) < '9' OR `team_1` = '".$game['team_2']."' AND `team_2` = '".$game['team_1']."' AND `status` = '1' AND LENGTH(score) < '9' ORDER BY `id` DESC LIMIT 5");  $gols_1 = 0; $gols_2 = 0; $win_1 = 0; $win_2 = 0; $draw = 0;  while($history = $sql->fetch_assoc()){  $score  = $history['score']; $scores = explode("-", $score);  if($scores['0'] == $scores['1']){ $draw++;  if($history['team_1'] = $game['team_1'] && $history['team_2'] = $game['team_2']){ $gols_1 += $scores['0']; $gols_2 += $scores['1']; } else if($history['team_1'] = $game['team_2'] && $history['team_2'] = $game['team_1']){ $gols_1 += $scores['1']; $gols_2 += $scores['0']; }  }//draw  else if($scores['0'] > $scores['1']){  if($history['team_1'] = $game['team_1'] && $history['team_2'] = $game['team_2']){ $win_1++; $gols_1 += $scores['0']; $gols_2 += $scores['1']; }  else if($history['team_1'] = $game['team_2'] && $history['team_2'] = $game['team_1']){ $win_2++; $gols_2 += $scores['0']; $gols_1 += $scores['1']; }  }//win $history['team_1']   else if($scores['0'] < $scores['1']){  if($history['team_2'] = $game['team_1'] && $history['team_1'] = $game['team_2']){ $win_1++; $gols_1 += $scores['1']; $gols_2 += $scores['0']; }  else if($history['team_2'] = $game['team_2'] && $history['team_1'] = $game['team_1']){ $win_2++; $gols_2 += $scores['1']; $gols_1 += $scores['0']; }  }//win $history['team_2']    }//while   
Немного поиграл с кодом получилось вывести данные но считает не правильно! Есть две записи о играх двух команд Боруссия Д и ПСЖ Первая игра :2-1 Вторая: 0-2 То есть: $gols_1 = 2 $gols_2 = 3 $draw = 0 $win_1 = 1 $win_2 = 1 а по факту считает так: $gols_1 = 4 $gols_2 = 1 $draw = 0 $win_1 = 2 $win_2 = 0
Спасибо за внимание, кройте тему решил сам))
Онлайн: 0
Время:
Gen. 0.0775
(c) Bym.Guru 2010-2026