query("SELECT * FROM category ORDER BY orderby");
while ($row = $res->fetchArray()) {
echo "".$row['name']."
\n";
$res2 = $db->query("SELECT * FROM level WHERE category_id = ".$row['id']." ORDER BY orderby");
while ($row2 = $res2->fetchArray()) {
echo "[";
echo levelComplete($row2['id']) ? "X" : " ";
echo "] ".$row2['name']."
\n";
}
}
function levelComplete($l) {
global $db;
$q = $db->query("SELECT * FROM solns WHERE user_id = ".$_SESSION['cs4g_user_id']." AND level_id = $l");
$row = $q->fetchArray();
return $row !== false && $row['completed'] == 1;
}
include 'footer.inc.php';
?>