i know this is possible cuz the milonic site does it well i assume they do because in there source you can see menu_data.php as there script source
k so in my main page i have this
Code: Select all
<?
$sql = "SELECT * FROM menu WHERE menuname = 'mainmenu'";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
if ($row[4] != ""){ //row[4] = showmenu, if showmenu!="" then
echo "<a href=\"$row[3]\" class=\"menu\" onmouseover=\"popup('$row[4]',1)\" onmouseout=popdown()>$row[2]</a>\n";
}
else { //row[4] = showmenu, if showmenu="" then
echo "<a href=\"$row[3]\" class=\"menu\">$row[2]</a>\n";
}
}
?>
the tables in my database are set up like so
id , menuname , title , url , showmenu
now in my menu_data.php file i have the following
Code: Select all
_menuCloseDelay=500 // The time delay for menus to remain visible on mouse out
_menuOpenDelay=150 // The time delay before menus open on mouse over
_followSpeed=5 // Follow scrolling speed
_followRate=40 // Follow scrolling Rate
_subOffsetTop=10 // Sub menu top offset
_subOffsetLeft=-10 // Sub menu left offset
_scrollAmount=3 // Only needed for Netscape 4.x
_scrollDelay=20 // Only needed for Netcsape 4.x
with(menuStyle=new mm_style()){
onbgcolor="#EDEDED";
oncolor="#000000";
offbgcolor="#3D3D3D";
offcolor="#E5E5E5";
padding=1;
fontsize=11;
fontstyle="normal";
separatorsize=10;
separatorcolor="#3D3D3D";
fontfamily="Arial Narrow";
overfilter="Fade(duration=0.2);Alpha(opacity=90);Shadow(color='#777777', Direction=135, Strength=5)";
outfilter="randomdissolve(duration=0.3)";
}
<?
$i=0;
$sql = "SELECT * FROM menu WHERE menuname != 'mainmenu'";
$result = mysql_query($sql);
while ($row = mysql_fetch_row($result)) {
$name[$i] = $row[1];
$sql .= " && menuname != '$name[$i]' ";
echo "with(milonic=new menuname(\"$row[1]\")){\n";
echo "style=menuStyle;\n";
echo "overflow=\"scroll\";\n";
$sql2 = "SELECT * FROM menu WHERE menuname = '$name[$i]'";
$result2 = mysql_query($sql2);
$i++;
while ($row = mysql_fetch_row($result2)) {
if($row[4] == "" && $row[3] != ""){
echo "aI(\"text=$row[2];url=$row[3];\");\n";
} elseif ($row[4]!="" && $row[3] != "") {
echo "aI(\"text=$row[2];\");\n";
} elseif ($row[4]!="" && $row[3] = "") {
echo "aI(\"text=$row[2];showmenu=$row[4];\");\n";
}
}
echo "}\n";
}
?>
drawMenus();
Code: Select all
$sql .= " && menuname != '$name[$i]' ";
Code: Select all
_menuCloseDelay=500 // The time delay for menus to remain visible on mouse out
_menuOpenDelay=150 // The time delay before menus open on mouse over
_followSpeed=5 // Follow scrolling speed
_followRate=40 // Follow scrolling Rate
_subOffsetTop=10 // Sub menu top offset
_subOffsetLeft=-10 // Sub menu left offset
_scrollAmount=3 // Only needed for Netscape 4.x
_scrollDelay=20 // Only needed for Netcsape 4.x
with(menuStyle=new mm_style()){
onbgcolor="#EDEDED";
oncolor="#000000";
offbgcolor="#3D3D3D";
offcolor="#E5E5E5";
padding=1;
fontsize=11;
fontstyle="normal";
separatorsize=10;
separatorcolor="#3D3D3D";
fontfamily="Arial Narrow";
overfilter="Fade(duration=0.2);Alpha(opacity=90);Shadow(color='#777777', Direction=135, Strength=5)";
outfilter="randomdissolve(duration=0.3)";
}
with(milonic=new menuname("area_office")){
style=menuStyle;
overflow="scroll";
aI("text=CPAC;url=index.php?page=area_office§ion=CPAC;");
aI("text=AMT;url=index.php?page=area_office§ion=AMT;");
aI("text=AHT;url=index.php?page=area_office§ion=AHT;");
}
with(milonic=new menuname("area_office")){
style=menuStyle;
overflow="scroll";
aI("text=CPAC;url=index.php?page=area_office§ion=CPAC;");
aI("text=AMT;url=index.php?page=area_office§ion=AMT;");
aI("text=AHT;url=index.php?page=area_office§ion=AHT;");
}
with(milonic=new menuname("area_office")){
style=menuStyle;
overflow="scroll";
aI("text=CPAC;url=index.php?page=area_office§ion=CPAC;");
aI("text=AMT;url=index.php?page=area_office§ion=AMT;");
aI("text=AHT;url=index.php?page=area_office§ion=AHT;");
}