| Player | $m1) { $didmatch = 1;}
if ($twomatch > $m2) { $didmatch = 1;}
if ($threematch > $m3) { $didmatch = 1;}
if ($fourmatch > $m4) { $didmatch = 1;}
if ($fivematch > $m5) { $didmatch = 1;}
if ($sixmatch > $m6) { $didmatch = 1;}
if ($didmatch == 1) { $lottomatches .= "id=$lotto[id] OR "; }
$didmatch = 0;
$m1 = $onematch;
$m2 = $twomatch;
$m3 = $threematch;
$m4 = $fourmatch;
$m5 = $fivematch;
$m6 = $sixmatch;
}
if ($onematch > 0) { $color1 = "yellow";} else {$color1 = "white";}
if ($twomatch > 0) { $color2 = "yellow";} else {$color2 = "white";}
if ($threematch > 0) { $color3 = "yellow";} else {$color3 = "white";}
if ($fourmatch > 0) { $color4 = "yellow";} else {$color4 = "white";}
if ($fivematch > 0) { $color5 = "yellow";} else {$color5 = "white";}
if ($sixmatch > 0) { $color6 = "yellow"; } else {$color6 = "white";}
echo "| $nt[name] | $nt[one] | $nt[two] | $nt[three] | $nt[four] | $nt[five] | $nt[six] | ";
}
?>
|
| LOTTO NUMBERS | 0) { $color1 = "yellow";} else {$color1 = "white";}
if ($twomatch > 0) { $color2 = "yellow";} else {$color2 = "white";}
if ($threematch > 0) { $color3 = "yellow";} else {$color3 = "white";}
if ($fourmatch > 0) { $color4 = "yellow";} else {$color4 = "white";}
if ($fivematch > 0) { $color5 = "yellow";} else {$color5 = "white";}
if ($sixmatch > 0) { $color6 = "yellow"; } else {$color6 = "white";}
echo "| $lotto[one] | $lotto[two] | $lotto[three] | $lotto[four] | $lotto[five] | $lotto[six] | $lotto[date] | ";
}
echo "
";
include 'closedb.php';
} else {
include 'config.php';
include 'opendb.php';
$query2 = "select * from lotto_numbers order by id asc";
//mysql_query($query2) or die('Error, Selecting Data');
$query = "select * from lotto_users order by name asc";
//mysql_query($query) or die('Error, Selecting Data');
$rt=mysql_query($query);
echo mysql_error();
?>| Players | 0) { $color1 = "yellow"; $veryclose = $veryclose+1;} else {$color1 = "white";}
if ($twomatch > 0) { $color2 = "yellow"; $veryclose = $veryclose+1;} else {$color2 = "white";}
if ($threematch > 0) { $color3 = "yellow"; $veryclose = $veryclose+1;} else {$color3 = "white";}
if ($fourmatch > 0) { $color4 = "yellow"; $veryclose = $veryclose+1;} else {$color4 = "white";}
if ($fivematch > 0) { $color5 = "yellow"; $veryclose = $veryclose+1;} else {$color5 = "white";}
if ($sixmatch > 0) { $color6 = "yellow"; $veryclose = $veryclose+1;} else {$color6 = "white";}
if ($onematch > 0 AND $twomatch > 0 AND $threematch > 0 AND $fourmatch > 0 AND $fivematch > 0 AND $sixmatch > 0) { $WINNER = 1;} else {$WINNER = 0;}
if ($WINNER == 1) {$winnercolor="red"; echo "| $nt[name] WINS! | ";} else {$winnercolor="white";}
if ($veryclose == 5) { $winnercolor="purple"; $count5 = $count5+1;}
if ($veryclose == 4) { $winnercolor="green"; $count4 = $count4+1;}
if ($veryclose == 3) { $winnercolor="pink"; $count3 = $count3+1;}
if ($username == $nt[name]) { $spaces = " ] ";} else {$spaces = "";}
$username = $nt[name];
echo "| $spaces$nt[name] | $nt[one] | $nt[two] | $nt[three] | $nt[four] | $nt[five] | $nt[six] | ";
$count = $count + 1;
}
Echo "| $count Total Players | ";
Echo "| $count3 with 3 Numbers | ";
Echo "| $count4 with 4 Numbers | ";
Echo "| $count5 with 5 Numbers | ";
include 'closedb.php';
?>
|
| LOTTO NUMBERS | $lotto[one] | $lotto[two] | $lotto[three] | $lotto[four] | $lotto[five] | $lotto[six] | $lotto[date] | ";
$count2 = $count2 + 1;
}
Echo "| $count2 Total Drawing | ";
echo "
";
include 'closedb.php';
}
?>
|