Joins (Opgelost)

SELECT 
	menu_cats.view AS mc_view, 
	menu_cats.level AS mc_level,
	menu_cats.naam AS mc_naam,
	menu_links.view AS ml_view,
	menu_links.level AS ml_level,
	menu_links.link AS ml_link,
	menu_links.naam AS ml_naam
FROM 
	menu_links
RIGHT JOIN
	menu_cats
ON
	(menu_cats.id = menu_links.cat)

SELECT 
	menu_cats.view AS mc_view, 
	menu_cats.level AS mc_level,
	menu_cats.naam AS mc_naam,
	menu_links.view AS ml_view,
	menu_links.level AS ml_level,
	menu_links.link AS ml_link,
	menu_links.naam AS ml_naam
FROM 
	menu_links
RIGHT JOIN
	menu_cats
ON
	(menu_cats.id = menu_links.cat)

SELECT c.view AS mc_view, c.level AS mc_level, c.naam AS mc_naam, l.view AS ml_view, l.level AS ml_level, l.link AS ml_link, l.naam AS ml_naam FROM menu_links l RIGHT JOIN menu_cats c ON c.id = l.cat ORDER BY c.id ASC

SELECT c.view AS mc_view, c.level AS mc_level, c.naam AS mc_naam, l.view AS ml_view, l.level AS ml_level, l.link AS ml_link, l.naam AS ml_naam FROM menu_links l RIGHT JOIN menu_cats c ON c.id = l.cat ORDER BY c.id ASC

while( ... )
{
   echo $hoofd . '<br />';
   echo $sub    . '<br />';
}

while( ... )
{
   echo $hoofd . '<br />';
   echo $sub    . '<br />';
}

<?PHP
$sQueryMenu = "
SELECT 
	menu_cats.view AS mc_view, 
	menu_cats.level AS mc_level,
	menu_cats.naam AS mc_naam,
	menu_cats.id AS mc_id,
	menu_links.view AS ml_view,
	menu_links.level AS ml_level,
	menu_links.link AS ml_link,
	menu_links.naam AS ml_naam
FROM 
	menu_links, menu_cats
WHERE
	menu_cats.id = menu_links.cat";
$rResultMenu = $oMySQL->query($sQueryMenu);
$iCatId = 0;
while($aFetchMenu = MySQL_Fetch_Assoc($rResultMenu))
{
	if($oToegang->check($aFetchMenu['mc_level'], $aFetchMenu['mc_view'], (IsSet($_SESSION['id']) ? $aLeden['level'] : 0)))
	{
		if($iCatId != $aFetchMenu['mc_id'])
		{
			if(IsSet($bNext) && $bNext)
			{
				$oTpl->newBlock("MENU_ROW_MARGIN");
			}
			$oTpl->newBlock("MENU");
			$oTpl->newBlock("MENU_HEAD");
			$oTpl->assign("MENU_HEAD_TITLE", $aFetchMenu['mc_naam']);
			$iCatId = $aFetchMenu['mc_id'];
		}
		if($oToegang->check($aFetchMenu['ml_level'], $aFetchMenu['ml_view'], (IsSet($_SESSION['id']) ? $aLeden['level'] : 0)))
		{
			$oTpl->newBlock("MENU_ROW");
			$oTpl->assign(array(
				"MENU_ROW_PAGE" => $aFetchMenu['ml_link'],
				"MENU_ROW_LINK" => $aFetchMenu['ml_naam']
			));
		}
	}
	$bNext = true;
}

<?PHP
$sQueryMenu = "
SELECT 
	menu_cats.view AS mc_view, 
	menu_cats.level AS mc_level,
	menu_cats.naam AS mc_naam,
	menu_cats.id AS mc_id,
	menu_links.view AS ml_view,
	menu_links.level AS ml_level,
	menu_links.link AS ml_link,
	menu_links.naam AS ml_naam
FROM 
	menu_links, menu_cats
WHERE
	menu_cats.id = menu_links.cat";
$rResultMenu = $oMySQL->query($sQueryMenu);
$iCatId = 0;
while($aFetchMenu = MySQL_Fetch_Assoc($rResultMenu))
{
	if($oToegang->check($aFetchMenu['mc_level'], $aFetchMenu['mc_view'], (IsSet($_SESSION['id']) ? $aLeden['level'] : 0)))
	{
		if($iCatId != $aFetchMenu['mc_id'])
		{
			if(IsSet($bNext) && $bNext)
			{
				$oTpl->newBlock("MENU_ROW_MARGIN");
			}
			$oTpl->newBlock("MENU");
			$oTpl->newBlock("MENU_HEAD");
			$oTpl->assign("MENU_HEAD_TITLE", $aFetchMenu['mc_naam']);
			$iCatId = $aFetchMenu['mc_id'];
		}
		if($oToegang->check($aFetchMenu['ml_level'], $aFetchMenu['ml_view'], (IsSet($_SESSION['id']) ? $aLeden['level'] : 0)))
		{
			$oTpl->newBlock("MENU_ROW");
			$oTpl->assign(array(
				"MENU_ROW_PAGE" => $aFetchMenu['ml_link'],
				"MENU_ROW_LINK" => $aFetchMenu['ml_naam']
			));
		}
	}
	$bNext = true;
}