-
<%
$menu_table = mysql_query("
SELECT * FROM menu
WHERE Location=1 AND ParentCode is NULL
ORDER BY OrderNum ASC
");
while ($menu_row = mysql_fetch_array($menu_table))
{
switch ($menu_row ["ModuleCode"])
{
case 1:
echo '
- '.$menu_row["eName"].' '; break; case 2: echo '
- '; echo $menu_row["eName"].' '; break; case 4: $href = (!$menu_row["Link"]) ? "services.php" :$menu_row["Link"]; echo '
- '.$menu_row["eName"].'';
echo '
- ';
$top=true;
$service_table = mysql_query("
SELECT Code, eName, 'service' as Type, OrderNum FROM services WHERE CategoryCode is NULL
UNION
SELECT Code, eName, 'category' as Type, OrderNum FROM servicecategory WHERE ParentCode is NULL
ORDER BY OrderNum
");
while ($service_row = mysql_fetch_array($service_table))
{
if ($top)
{
echo '
- '; $top = false; }else echo '
- '; echo ''; //echo ''; echo $service_row["eName"]; echo ' '; } echo '
';
break;
default :
$href = (!$menu_row["Link"]) ? "#" :$menu_row["Link"];
echo ' - '.$menu_row["eName"].'';
echo '
- ';
$top = true;
$submenu_table = mysql_query("
SELECT * FROM menu
WHERE Location=1 AND ParentCode=".$menu_row["Code"]
);
while ($submenu_row = mysql_fetch_array($submenu_table))
{
if ($top)
{
echo '
- '; $top = false; }else echo '
- '; switch ($submenu_row ["ModuleCode"]) { case 1: echo ''; echo $submenu_row["eName"].' '; break; case 2: echo ''; echo $submenu_row["eName"].'
';
break;
default :
echo ''. $submenu_row["eName"].'';
break;
}
}
echo '
- '; $first = false; }else echo '
- '; switch ($menu_row ["ModuleCode"]) { case 1: echo ''.$menu_row["eName"].' '; break; case 2: echo ''; echo $menu_row["eName"].''; break; case 4: echo ''.$menu_row["eName"].''; break; default : echo ''.$menu_row["eName"].''; break; } } %>
- © 2013 McTough Day Rad - Design by Ecomiran
-
<%
$first = true ;
$menu_table = mysql_query("
SELECT * FROM menu
WHERE Location=2 AND ParentCode is NULL
ORDER BY OrderNum ASC
");
while ($menu_row = mysql_fetch_array($menu_table))
{
if ($first)
{
echo '