0) {
list($bestMoves, $byName, $solution) = mysql_fetch_row($result);
//echo "Best solution for this map: $bestMoves by $byName";
//$map = MergeMapSolution($map, $solution);
//echo DisplayMap($map, $mapID);
}
echo '
';
echo "
";
echo '
';
echo $stats;
echo '
';
echo '
';
echo "Best solution for this map: $bestMoves by $byName ";
echo DisplayMap($map, $mapID, true, 2);
echo '
';
echo '
';
}
function displaystats($result, $caption = NULL) {
//Get names.
$headers .= "
Rank | ";
$headers .= "
Name | ";
$headers .= "
Moves | ";
$headers .= "
Time taken | ";
//Start table
$r .= "
";
$r .= "$caption";
//Headers on the top. including Rank.
$r .= "";
$r .= $headers;
$r .= "
";
$i = 1;
while ($row = mysql_fetch_assoc($result)) {
$rowcontent = '';
$mapid = $row['mapID'];
$solution = $row['solution'];
$r .= "";
$r .= "| $i | ";
$r .= '' . $row['Name'] . ' | ';
$r .= '' . $row['Moves'] . ' | ';
$r .= '' . $row['Timetaken'] . ' | ';
$r .= "
";
$i++;
}
$r .= "
";
return $r;
}
function mysql_field_array( $query ) {
$field = mysql_num_fields( $query );
for ( $i = 0; $i < $field; $i++ ) {
$names[] = mysql_field_name( $query, $i );
}
return $names;
}
// $sql = 'select columnname etc'
// $result = mysql_query($sql);
// while ($data[] = mysql_fetch_row($result));
// $data[1]['columnname'] == 'my data';
yesterdayMaze(1, 'Simple');
yesterdayMaze(2, 'Normal');
yesterdayMaze(3, 'Complex');
yesterdayMaze(4, 'Special');
?>