Amigo tengo esto, pero no me funciona ya que solo me devuelve un dato y son varios, ademas los campos que sumo no me estan funcionando ya que me imprimen 0, dime que cambiar... ?
Código PHP:
$conta = 0;
$previousNumGame = "";
$previousTeams = "";
$previousTime = "";
$previousScore = "";
$counterTickets = 0;
$counterRisk = 0;
$counterWinLoss = 0;
$IdGames = "";
while($dataGames = $strDataGames->fetch(PDO::FETCH_ASSOC)){
if($conta != 0){
if($dataGames['NumGame'] == $previousNumGame && $dataGames['Teams'] == $previousTeams){
$previousNumGame = $dataGames['NumGame'];
$previousTeams = $dataGames['Teams'];
$time1 = strtotime($previousTime);
$time2 = strtotime($dataGames['Time']);
if($time1 < $time2)
$previousTime = $dataGames['Time'];
else
$previousTime = $previousTime;
$previousScore = $dataGames['Score'];
$counterTickets = $counterTickets + $dataGames['Tickets'];
$counterRisk = $counterRisk + $dataGames['Risk'];
$counterWinLoss = $counterWinLoss + $dataGames['WinLoss'];
$IdGames .= $dataGames['IdGame']."+";
}else{
$response .= "<tr>";
$response .= "<td>".$previousTime."</td>";
$response .= "<td>".$previousNumGame."</td>";
$response .= "<td>".$previousTeams."</td>";
$response .= "<td>".$previousScore."</td>";
$response .= "<td><a href='#' rel='' onClick='openInfoWager(this);'>".$counterTickets."</a></td>";
$response .= "<td>".$counterRisk."</td>";
$response .= "<td>".$counterWinLoss."</td>";
$todayFigure = $todayFigure + $counterWinLoss; // resto cuando el usuario perdio.
}
$response .= "<td>".$todayFigure."</td>";
$response .= "</tr>";
$counterTickets = 0;
$counterRisk = 0;
$counterWinLoss = 0;
$IdGames = "";
}else{
$previousNumGame = $dataGames['NumGame'];
$previousTeams = $dataGames['Teams'];
$previousTime = $dataGames['Time'];
$previousScore = $dataGames['Score'];
$counterTickets = $dataGames['Tickets'];
$counterRisk = $dataGames['Risk'];
$counterWinLoss = $dataGames['WinLoss'];
$IdGames = $dataGames['IdGame']."+";
}
$conta += 1;
}//end while