Results (new version)
List of results
[insert_php]
$sql2 = “SELECT * FROM comp1tracks”;
$sql3 = “CREATE TABLE comp1tracks (trackname varchar(255))”;
$sql4 = “INSERT INTO comp1tracks (trackname) VALUES (‘Comp1CircleTrack’)”;
$sql5 = “CREATE TABLE Comp1CircleTrack (username varchar(255), result varchar(255))”;
$sql6 = “INSERT INTO Comp1CircleTrack (username, result) VALUES (‘User0′,’Comp1CircleTrackUser0’)”;
$sql7 = “CREATE TABLE Comp1CircleTrackUser0 (level int, runs int, dtg int, dg int, time int, timelimit int, score int)”;
$sql8 = “INSERT INTO Comp1CircleTrackUser0 VALUES (0,1,2,3,4,5,6)”;
$sql9 = “INSERT INTO Comp1CircleTrackUser0 VALUES (1,2,3,4,5,6,7)”;
$res2 = mysql_query($sql2)or die(mysql_error());
while($row = mysql_fetch_array($res2)){
echo “
“.$row[‘trackname’].”
“;
$trackSql = “SELECT * FROM “.$row[‘trackname’];
$res3 = mysql_query($trackSql)or die(mysql_error());
while($row2 = mysql_fetch_array($res3)){
echo “
“.$row2[‘username’].”
“;
$resultsSql = “SELECT * FROM “.$row2[‘result’];
$res3 = mysql_query($resultsSql)or die(mysql_error());
echo “
Level | Runs | DiaToCatch | DiaCaught | Time | Time Limit | Score |
---|---|---|---|---|---|---|
“.$level.” | “.$runs.” | “.$diaToCatch.” | “.$diaCaught.” | “.$time.” | “.$timeLimit.” | “.$score.” |
“;
}
}
[/insert_php]