Addind some results

Original - php Code <?php . . . . //find users points. $resultxx = mysql_query("SELECT * FROM FT_table, members WHERE round = '{$_POST['round']}' AND member_id = ID") or die(mysql_error()); $resultx = mysql_query("SELECT * FROM FT_results WHERE round = '{$_POST['round']}'") or die(mysql_error()); $rowxx = mysql_fetch_array($resultxx); $rowx = mysql_fetch_array($resultx); //determine how many tips they got correct $correct = 0; if($rowxx['game1'] == $rowx['game1']) { $correct += 1; } if($rowxx['game2'] == $rowx['game2']) { $correct += 1; } if($rowxx['game3'] == $rowx['game3']) { $correct += 1; } if($rowxx['game4'] == $rowx['game4']) { $correct += 1; } if($rowxx['game5'] == $rowx['game5']) { $correct += 1; } if($rowxx['game6'] == $rowx['game6']) { $correct += 1; } if($rowxx['game7'] == $rowx['game7']) { $correct += 1; } if($rowxx['game8'] == $rowx['game8']) { $correct += 1; } //insert the amount of correct answers they got. mysql_query("UPDATE members SET FT_points = FT_points + '$correct' WHERE ID = '{$rowxx['member_id']}'") or die(mysql_error()); ?>

 
<?php
.
.
.
.
//find users points.
$resultxx = mysql_query("SELECT * FROM FT_table, members WHERE round = '{$_POST['round']}' AND member_id = ID")
    or die(mysql_error());
$resultx = mysql_query("SELECT * FROM FT_results WHERE round = '{$_POST['round']}'")
    or die(mysql_error());
$rowxx = mysql_fetch_array($resultxx);
$rowx = mysql_fetch_array($resultx);
 
//determine how many tips they got correct
$correct = 0;
if($rowxx['game1'] == $rowx['game1'])
{
    $correct += 1;
}
if($rowxx['game2'] == $rowx['game2'])
{
    $correct += 1;
}
if($rowxx['game3'] == $rowx['game3'])
{
    $correct += 1;
}
if($rowxx['game4'] == $rowx['game4'])
{
    $correct += 1;
}
if($rowxx['game5'] == $rowx['game5'])
{
    $correct += 1;
}
if($rowxx['game6'] == $rowx['game6'])
{
    $correct += 1;
}
if($rowxx['game7'] == $rowx['game7'])
{
    $correct += 1;
}
if($rowxx['game8'] == $rowx['game8'])
{
    $correct += 1;
}
 
//insert the amount of correct answers they got.
mysql_query("UPDATE members SET FT_points = FT_points + '$correct' WHERE ID = '{$rowxx['member_id']}'")
    or die(mysql_error());
?> 

Original - php Code <? //determine how many tips they got correct $correct = 0; for($i=1; $i>8; $i++) { $game = "game$i"; if($rowxx['$game'] == $rowx['$game']) { $correct += 1; } } ?>

 
<?
//determine how many tips they got correct
$correct = 0;
for($i=1; $i>8; $i++)
{
    $game = "game$i";
    if($rowxx['$game'] == $rowx['$game'])
    {
        $correct += 1;
    }
}
?>