|
$result = mysql_query("SELECT * FROM Content WHERE Visible = 1 AND MenuID = ".$menuid." ORDER by ContentID",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
echo ''.$myrow["Title"].'
';
echo '';
$pic = mysql_query("SELECT * FROM Images WHERE ContentID=".$myrow["ContentID"],$db);
if ($mypic = mysql_fetch_array($pic)) {
echo ' ';
}
echo $myrow["Content"].' ';
}
while ($myrow = mysql_fetch_array($result));
}
function popChildren3($newmenuid,$cnt) {
$cntnew2 = $cnt + 1;
$result2 = mysql_query("select * from Menu where ParentID=".$newmenuid." order by MOrder, MenuID");
if (mysql_num_rows($result2)!=0) {
if ($myrow = mysql_fetch_array($result2)) {
if (($cntnew2 >= 1 ) AND ($myrow["ParentID"] == $_REQUEST['menuid'] )) {
echo ' ';
echo '';
}
do {
if (($cntnew2 >= 1 ) AND ($myrow["ParentID"] == $_REQUEST['menuid'])) {
if ($_REQUEST['menuid'] > 1085) {
echo '- ';
if (isset($_SESSION['userlogin'])) {
echo '';
}
echo $myrow["Description"];
if (isset($_SESSION['userlogin'])) {
echo '';
}
echo '
';
} else {
echo '- '.$myrow["Description"].'
'; }
}
popChildren3($myrow["MenuID"],$cntnew2);
}
while ($myrow = mysql_fetch_array($result2));
if (($cntnew2 >= 1 ) AND ($myrow["ParentID"] == $_REQUEST['menuid'])) { echo ' ';}
}
}
mysql_free_result($result2);
}
$cntnew = 0;
$result = mysql_query("SELECT * FROM Menu WHERE ParentID = 0 ORDER BY MOrder, MenuID",$db);
if ($myrow = mysql_fetch_array($result)) {
do {
popChildren3($myrow["MenuID"],$cntnew);
}
while ($myrow = mysql_fetch_array($result));
}
?>
|