require('../include/database.php');
?>
LANGDON X DOT COM - Image Puzzle High Scores
Completed Puzzle Results (Under Construction):
| LEVEL | USERNAME | SCORE |
$result = mysql_query('SELECT * FROM PUZZLE_FILE, PUZZLE_USER, PUZZLE_USER_STATISTIC pus
WHERE pkPUZZLE_USER_ID = pus.fkPUZZLE_USER_ID
AND pkPUZZLE_FILE_ID = fkPUZZLE_FILE_ID
AND MOVES IS NOT NULL
ORDER BY pkPUZZLE_FILE_ID, PARTS, MOVES, SECONDS');
while ($row = mysql_fetch_array($result))
{
if (($last_FILENAME != '') && ($last_FILENAME != $row['FILENAME']))
print ' |
';
print '' . (($last_FILENAME != $row['FILENAME']) ? $row['FILENAME'] : '') . ' | ';
print '' . sqrt($row['PARTS']) . 'x' . sqrt($row['PARTS']) . ' | ' . $row['USERNAME'] . ' | ' . $row['MOVES'] . ' moves in ' . $row['SECONDS'] . ' seconds. |
';
$last_FILENAME = $row['FILENAME'];
}
mysql_close($connection)
?>