Anonymous

// page
$pid = (isset($_GET['pid'])) ? $_GET['pid'] : 1;

// navigaatio
//--päätaso
$sql = "SELECT * FROM " . PAGES_TABLE . " WHERE parent is NULL";
$navigationStageOne = $db->getAll($sql);
$tpl->assign('navigationStageOne', $navigationStageOne);

//--taso2
$sql = "SELECT * FROM " . PAGES_TABLE . " WHERE parent = $pid";
$navigationStageTwo = $db->getAll($sql);
$tpl->assign('navigationStageTwo', $navigationStageTwo);
//--taso3

$sql = "SELECT * FROM " . PAGES_TABLE . " WHERE parent = $pid";
$navigationStageThree = $db->getAll($sql);
$tpl->assign('navigationStageThree', $navigationStageThree);