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 “

“;
echo “

“;
while($row3 = mysql_fetch_array($res3)){
$level = $row3[‘level’];
$runs = $row3[‘runs’];
$diaToCatch = $row3[‘dtg’];
$diaCaught = $row3[‘dg’];
$time = $row3[‘time’];
$timeLimit = $row3[‘timelimit’];
$score = $row3[‘score’];

echo “

“;

} // End our while loop
echo “

Level Runs DiaToCatch DiaCaught Time Time Limit Score
“.$level.” “.$runs.” “.$diaToCatch.” “.$diaCaught.” “.$time.” “.$timeLimit.” “.$score.”

“;
}
}

[/insert_php]

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.