";
$result = mysql_query($sql) or die (mysql_error());
if ($level > 0 && mysql_num_rows($result) > 0)
{
$ulopn = "";
} else $ulopn = $ulcls = "";
$list .= $ulopn;
while ($row = mysql_fetch_row($result))
{
$list.= "".htmlspecialchars($row[2])."";
showTree($row[0],$level+1);
$list.="";
}
$list .= $ulcls;
}
//$list = "";
//$list .= "
";
showTree(0,0);
//$list .= "
";
//$list .= "
";
$smarty->assign('arr', $list);
$smarty->display("menu.tpl");
function MenuContent(){
global $link;
if( !isset($_GET['id_menu']) ) return false;
$id = intval($_GET['id_menu']);
$sql="SELECT *
FROM menu, texts, img
WHERE menu.id_menu = texts.id_menu AND menu.id_menu = img.id_menu AND menu.id_menu = $id";
$result=mysql_query ($sql, $link);
while($row = mysql_fetch_assoc($result)){
print_r($row);
}
}
if (isset($_GET['id_menu'])) MenuContent();
?>