Php samme værdi som hovedemenuen
Hej alle Eksperter.Jeg har et problem med min php hjemmeside, jeg er igang med at lave en menu til mit admin modul. Men problemet er at je ghar lavet en dropdown menu som indeholder nogle links men disse links skal kun vises hvis de har Mainid der er = med Dropdown menu's ID. Jeg kan lige Ligge min kode ind her så i kan se
I databasen betyder sr_0000009 = Sideindhold, det er der mine sider ligger samt hovedesiderne.
Mit problem ligger på Linje 151 i koden
===========================================
= Kode start =
===========================================
<?php require_once('../Connections/cms.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_cms, $cms);
$query_genvej = "SELECT * FROM SR_0000006";
$genvej = mysql_query($query_genvej, $cms) or die(mysql_error());
$row_genvej = mysql_fetch_assoc($genvej);
$totalRows_genvej = mysql_num_rows($genvej);
mysql_select_db($database_cms, $cms);
$query_Menu_hovedsider_forside = "SELECT * FROM SR_0000009 WHERE mainid = 1";
$Menu_hovedsider_forside = mysql_query($query_Menu_hovedsider_forside, $cms) or die(mysql_error());
$row_Menu_hovedsider_forside = mysql_fetch_assoc($Menu_hovedsider_forside);
$totalRows_Menu_hovedsider_forside = mysql_num_rows($Menu_hovedsider_forside);
$colname_Menu_hovedsider_Privat = "-1";
if (isset($_SERVER['mainid'])) {
$colname_Menu_hovedsider_Privat = $_SERVER['mainid'];
}
mysql_select_db($database_cms, $cms);
$query_Menu_hovedsider_Privat = sprintf("SELECT * FROM sr_0000009 WHERE mainid = %s", GetSQLValueString($colname_Menu_hovedsider_Privat, "int"));
$Menu_hovedsider_Privat = mysql_query($query_Menu_hovedsider_Privat, $cms) or die(mysql_error());
$row_Menu_hovedsider_Privat = mysql_fetch_assoc($Menu_hovedsider_Privat);
$totalRows_Menu_hovedsider_Privat = mysql_num_rows($Menu_hovedsider_Privat);
mysql_select_db($database_cms, $cms);
$query_Menu_hovedsider_Erhverv = "SELECT * FROM SR_0000009 WHERE mainid = 3";
$Menu_hovedsider_Erhverv = mysql_query($query_Menu_hovedsider_Erhverv, $cms) or die(mysql_error());
$row_Menu_hovedsider_Erhverv = mysql_fetch_assoc($Menu_hovedsider_Erhverv);
$totalRows_Menu_hovedsider_Erhverv = mysql_num_rows($Menu_hovedsider_Erhverv);
mysql_select_db($database_cms, $cms);
$query_Menu_eks_forside = "SELECT * FROM SR_0000004 WHERE mainid = 1";
$Menu_eks_forside = mysql_query($query_Menu_eks_forside, $cms) or die(mysql_error());
$row_Menu_eks_forside = mysql_fetch_assoc($Menu_eks_forside);
$totalRows_Menu_eks_forside = mysql_num_rows($Menu_eks_forside);
mysql_select_db($database_cms, $cms);
$query_menu_eks_Privat = "SELECT * FROM SR_0000004 WHERE mainid = 2";
$menu_eks_Privat = mysql_query($query_menu_eks_Privat, $cms) or die(mysql_error());
$row_menu_eks_Privat = mysql_fetch_assoc($menu_eks_Privat);
$totalRows_menu_eks_Privat = mysql_num_rows($menu_eks_Privat);
mysql_select_db($database_cms, $cms);
$query_menu_eks_Erhverv = "SELECT * FROM SR_0000004 WHERE mainid = 3";
$menu_eks_Erhverv = mysql_query($query_menu_eks_Erhverv, $cms) or die(mysql_error());
$row_menu_eks_Erhverv = mysql_fetch_assoc($menu_eks_Erhverv);
$totalRows_menu_eks_Erhverv = mysql_num_rows($menu_eks_Erhverv);
mysql_select_db($database_cms, $cms);
$query_Menu_eks_vagtydelser = "SELECT * FROM SR_0000004 WHERE mainid = 4";
$Menu_eks_vagtydelser = mysql_query($query_Menu_eks_vagtydelser, $cms) or die(mysql_error());
$row_Menu_eks_vagtydelser = mysql_fetch_assoc($Menu_eks_vagtydelser);
$totalRows_Menu_eks_vagtydelser = mysql_num_rows($Menu_eks_vagtydelser);
mysql_select_db($database_cms, $cms);
$query_Menu_hovedeside_vagtydelser = "SELECT * FROM SR_0000009 WHERE mainid = 4";
$Menu_hovedeside_vagtydelser = mysql_query($query_Menu_hovedeside_vagtydelser, $cms) or die(mysql_error());
$row_Menu_hovedeside_vagtydelser = mysql_fetch_assoc($Menu_hovedeside_vagtydelser);
$totalRows_Menu_hovedeside_vagtydelser = mysql_num_rows($Menu_hovedeside_vagtydelser);
mysql_select_db($database_cms, $cms);
$query_Menu_eks_job = "SELECT * FROM SR_0000004 WHERE mainid = 5";
$Menu_eks_job = mysql_query($query_Menu_eks_job, $cms) or die(mysql_error());
$row_Menu_eks_job = mysql_fetch_assoc($Menu_eks_job);
$totalRows_Menu_eks_job = mysql_num_rows($Menu_eks_job);
mysql_select_db($database_cms, $cms);
$query_Menu_hovedeside_job = "SELECT * FROM SR_0000009 WHERE mainid = 5";
$Menu_hovedeside_job = mysql_query($query_Menu_hovedeside_job, $cms) or die(mysql_error());
$row_Menu_hovedeside_job = mysql_fetch_assoc($Menu_hovedeside_job);
$totalRows_Menu_hovedeside_job = mysql_num_rows($Menu_hovedeside_job);
mysql_select_db($database_cms, $cms);
$query_Menu_eks_about = "SELECT * FROM SR_0000004 WHERE mainid = 6";
$Menu_eks_about = mysql_query($query_Menu_eks_about, $cms) or die(mysql_error());
$row_Menu_eks_about = mysql_fetch_assoc($Menu_eks_about);
$totalRows_Menu_eks_about = mysql_num_rows($Menu_eks_about);
mysql_select_db($database_cms, $cms);
$query_Menu_hovedeside_about = "SELECT * FROM SR_0000009 WHERE mainid = 6";
$Menu_hovedeside_about = mysql_query($query_Menu_hovedeside_about, $cms) or die(mysql_error());
$row_Menu_hovedeside_about = mysql_fetch_assoc($Menu_hovedeside_about);
$totalRows_Menu_hovedeside_about = mysql_num_rows($Menu_hovedeside_about);
mysql_select_db($database_cms, $cms);
$query_headpage = "SELECT * FROM sr_0000009 WHERE hdmenu = 1";
$headpage = mysql_query($query_headpage, $cms) or die(mysql_error());
$row_headpage = mysql_fetch_assoc($headpage);
$totalRows_headpage = mysql_num_rows($headpage);
?>
<div class="arrowlistmenu">
<div id="firm" class="menuheader"><z<Grypgon ApS</div>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><div id="sitetree" class="menuheader expandable">Sider</div>
<ul class="categoryitems"><?php } ?>
<li><a id="sub-folder" class="subexpandable">Forside</a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedsider_forside['id']; ?>"><?php echo $row_Menu_hovedsider_forside['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedsider_forside = mysql_fetch_assoc($Menu_hovedsider_forside)); ?>
<?
$antal = mysql_num_rows($Menu_eks_forside);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_forside['id']; ?>"><?php echo $row_Menu_eks_forside['navn']; ?></a></li>
<?php } while ($row_Menu_eks_forside = mysql_fetch_assoc($Menu_eks_forside)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="sub-folder" class="subexpandable"><?php echo $row_headpage['overskrift']; ?></a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedsider_Privat['id']; ?>"><?php echo $row_Menu_hovedsider_Privat['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedsider_Privat = mysql_fetch_assoc($Menu_hovedsider_Privat)); ?>
<?
$antal = mysql_num_rows($menu_eks_Privat);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_Privat['id']; ?>"><?php echo $row_menu_eks_Privat['navn']; ?></a></li>
<?php } while ($row_menu_eks_Privat = mysql_fetch_assoc($menu_eks_Privat)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="sub-folder" class="subexpandable">Erhverv</a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedsider_Erhverv['id']; ?>"><?php echo $row_Menu_hovedsider_Erhverv['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedsider_Erhverv = mysql_fetch_assoc($Menu_hovedsider_Erhverv)); ?>
<?
$antal = mysql_num_rows($menu_eks_Erhverv);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_Erhverv['id']; ?>"><?php echo $row_menu_eks_Erhverv['navn']; ?></a></li>
<?php } while ($row_menu_eks_Erhverv = mysql_fetch_assoc($menu_eks_Erhverv)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="sub-folder" class="subexpandable">Vagtydelser</a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedeside_vagtydelser['id']; ?>"><?php echo $row_Menu_hovedeside_vagtydelser['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedeside_vagtydelser = mysql_fetch_assoc($Menu_hovedeside_vagtydelser)); ?>
<?
$antal = mysql_num_rows($Menu_eks_vagtydelser);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_vagtydelser['id']; ?>"><?php echo $row_Menu_eks_vagtydelser['navn']; ?></a></li>
<?php } while ($row_Menu_eks_vagtydelser = mysql_fetch_assoc($Menu_eks_vagtydelser)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="sub-folder" class="subexpandable">Job hos Gryphon</a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedeside_job['id']; ?>"><?php echo $row_Menu_hovedeside_job['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedeside_job = mysql_fetch_assoc($Menu_hovedeside_job)); ?>
<?
$antal = mysql_num_rows($Menu_eks_job);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_job['id']; ?>"><?php echo $row_Menu_eks_job['navn']; ?></a></li>
<?php } while ($row_Menu_eks_job = mysql_fetch_assoc($Menu_eks_job)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="sub-folder" class="subexpandable">Om Gryphon</a>
<ul class="subcategoryitems">
<?php do { ?>
<li><a id="sub-page_white" href="index.php?page=_esp&id=<?php echo $row_Menu_hovedeside_about['id']; ?>"><?php echo $row_Menu_hovedeside_about['overskrift']; ?></a></li>
<?php } while ($row_Menu_hovedeside_about = mysql_fetch_assoc($Menu_hovedeside_about)); ?>
<?
$antal = mysql_num_rows($Menu_eks_about);
if ($antal == "0")
{
//intet
}
elseif ($antal > "0")
{?>
<?php do { ?>
<li><a id="sub-page_white_link" href="index.php?page=_elink&id=<?php echo $row_Menu_eks_about['id']; ?>"><?php echo $row_Menu_eks_about['navn']; ?></a></li>
<?php } while ($row_Menu_eks_about = mysql_fetch_assoc($Menu_eks_about)); ?>
<? } ?>
<li><a href="#">Ekstra punkt</a></li>
</ul>
</li>
<li><a id="page_white_add" href="index.php?page=_creat">Tilføj side</a></li>
<li><a id="link_add" href="index.php?page=_clink">Tilføj link</a></li>
</ul>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><div id="sitetree" class="menuheader expandable">Hovedesider</div>
<ul class="categoryitems"><?php } ?>
<?php do { ?>
<li><a id="page_white_code" href="index.php?page=_ehdsp&id=<?php echo $row_headpage['id']; ?>"><?php echo $row_headpage['overskrift']; ?></a></li>
<?php } while ($row_headpage = mysql_fetch_assoc($headpage)); ?>
</ul>
<?php if (in_array($_SESSION['MM_UserGroup'], array(1,2,3,4,5))) { ?><div id="modules" class="menuheader expandable">Moduler (kommer snart)</div><?php } ?>
<ul class="categoryitems">
</ul>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><div id="controlpanel" class="menuheader expandable">Kontrolpanel</div><?php } ?>
<ul class="categoryitems">
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a id="subfolder" class="subexpandable">Menu Gallery</a><?php } ?>
<ul class="subcategoryitems">
<li><a href="#">Blue Color</a></li>
<li><a href="#">Green Color</a></li>
<li><a href="#">Orange Color</a></li>
<li><a href="#">Red Color</a></li>
<li><a href="#">Brown Color</a></li>
</ul>
</li>
<li><a id="subfolder" class="subexpandable">Menu Gallery</a>
<ul class="subcategoryitems">
<li><a href="#">Blue Color</a></li>
<li><a href="#">Green Color</a></li>
<li><a href="#">Orange Color</a></li>
<li><a href="#">Red Color</a></li>
<li><a href="#">Brown Color</a></li>
</ul>
</li>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/javatutors/">JavaScript tutorials</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/jsref/">JavaScript Reference</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/domref/">DOM Reference</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/dhtmltutors/">DHTML & CSS</a></li><?php } ?>
</ul>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><div id="tools" class="menuheader expandable">Værktøjer</div><?php } ?>
<ul class="categoryitems">
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/cutpastejava.shtml" >Free JavaScripts</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/javatutors/">JavaScript tutorials</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/jsref/">JavaScript Reference</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/domref/">DOM Reference</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a href="http://www.javascriptkit.com/dhtmltutors/">DHTML & CSS</a></li><?php } ?>
</ul>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><div id="help" class="menuheader expandable">Hjælp</div><?php } ?>
<ul class="categoryitems">
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a id="book_open" href="http://www.javascriptkit.com/cutpastejava.shtml" >Online Manual</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a id="help" href="http://www.javascriptkit.com/javatutors/">Spørgsmål</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a id="exclamation" href="http://www.javascriptkit.com/javatutors/">Fejlmelding</a></li><?php } ?>
<?php if (in_array($_SESSION['MM_UserGroup'], array(4,5))) { ?><li><a id="telephone" href="http://www.javascriptkit.com/jsref/">Kontakt</a></li><?php } ?>
</ul>
<div id="search" class="menuheader" style="cursor: default">Søg</div>
<div><span class="style39 style43 style45"><? echo "Velkommen ".$_SESSION["MM_Username"]; ?></span></div>
</div>
<?php
mysql_free_result($genvej);
mysql_free_result($Menu_hovedsider_forside);
mysql_free_result($Menu_hovedsider_Privat);
mysql_free_result($Menu_hovedsider_Erhverv);
mysql_free_result($Menu_eks_forside);
mysql_free_result($menu_eks_Privat);
mysql_free_result($menu_eks_Erhverv);
mysql_free_result($Menu_eks_vagtydelser);
mysql_free_result($Menu_hovedeside_vagtydelser);
mysql_free_result($Menu_eks_job);
mysql_free_result($Menu_hovedeside_job);
mysql_free_result($Menu_eks_about);
mysql_free_result($Menu_hovedeside_about);
mysql_free_result($headpage);
?>
===========================================
= Kode slut =
===========================================
