Der var lige et par fejl, du må ikke bruge session_start(); flere gange og den SKAL være øverst i din fil, der må ingen gang være et mellemrum eller kommentar før. Og du har brugt den 4 gange midt i koden ;-)
prøv følgene og sig hvad den udskriver:
<?php
session_start();
require_once('../Connections/cms.php');
$user = $_SESSION['MM_Username'];
$query = mysql_query("select * from brugere WHERE brugernavn = '$user'") or die (mysql_error());
$row=mysql_fetch_array($query);
echo "<br>";
echo "adgang felt indeholder: ";
echo $row['adgang'];
echo "<br>";
echo "session indeholder: ";
echo $user;
?>
<?php
/**
* @version $Id: index.php 8701 2006-10-01 19:10:07Z stingrey $
* @package
* @copyright Copyright (C) 2006 All rights reserved.
*/
// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
$logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
//to fully log out a visitor we need to clear the session varialbles
session_unregister('MM_Username');
session_unregister('MM_UserGroup');
$logoutGoTo = "../index.php";
if ($logoutGoTo) {
header("Location: $logoutGoTo");
exit;
}
}
?>
<?php
$MM_authorizedUsers = "";
$MM_donotCheckaccess = "true";
// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) {
// For security, start by assuming the visitor is NOT authorized.
$isValid = False;
// When a visitor has logged into this site, the Session variable MM_Username set equal to their username.
// Therefore, we know that a user is NOT logged in if that Session variable is blank.
if (!empty($UserName)) {
// Besides being logged in, you may restrict access to only certain users based on an ID established when they login.
// Parse the strings into arrays.
$arrUsers = Explode(",", $strUsers);
$arrGroups = Explode(",", $strGroups);
if (in_array($UserName, $arrUsers)) {
$isValid = true;
}
// Or, you may restrict access to only certain users based on their username.
if (in_array($UserGroup, $arrGroups)) {
$isValid = true;
}
if (($strUsers == "") && true) {
$isValid = true;
}
}
return $isValid;
}
$MM_restrictGoTo = "login.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {
$MM_qsChar = "?";
$MM_referrer = $_SERVER['PHP_SELF'];
if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0)
$MM_referrer .= "?" . $QUERY_STRING;
$MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
header("Location: ". $MM_restrictGoTo);
exit;
}
?>
<?php
mysql_select_db($database_cms, $cms);
$query_rsSubmenu2 = "SELECT * FROM sideindhold WHERE mainid = 2";
$rsSubmenu2 = mysql_query($query_rsSubmenu2, $cms) or die(mysql_error());
$row_rsSubmenu2 = mysql_fetch_assoc($rsSubmenu2);
$totalRows_rsSubmenu2 = mysql_num_rows($rsSubmenu2);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu3 = "SELECT * FROM sideindhold WHERE mainid = 3";
$rsSubmenu3 = mysql_query($query_rsSubmenu3, $cms) or die(mysql_error());
$row_rsSubmenu3 = mysql_fetch_assoc($rsSubmenu3);
$totalRows_rsSubmenu3 = mysql_num_rows($rsSubmenu3);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu4 = "SELECT * FROM sideindhold WHERE mainid = 4";
$rsSubmenu4 = mysql_query($query_rsSubmenu4, $cms) or die(mysql_error());
$row_rsSubmenu4 = mysql_fetch_assoc($rsSubmenu4);
$totalRows_rsSubmenu4 = mysql_num_rows($rsSubmenu4);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu5 = "SELECT * FROM sideindhold WHERE mainid = 5";
$rsSubmenu5 = mysql_query($query_rsSubmenu5, $cms) or die(mysql_error());
$row_rsSubmenu5 = mysql_fetch_assoc($rsSubmenu5);
$totalRows_rsSubmenu5 = mysql_num_rows($rsSubmenu5);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu1 = "SELECT * FROM sideindhold WHERE mainid = 1";
$rsSubmenu1 = mysql_query($query_rsSubmenu1, $cms) or die(mysql_error());
$row_rsSubmenu1 = mysql_fetch_assoc($rsSubmenu1);
$totalRows_rsSubmenu1 = mysql_num_rows($rsSubmenu1);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu6 = "SELECT * FROM sideindhold WHERE mainid = 6";
$rsSubmenu6 = mysql_query($query_rsSubmenu6, $cms) or die(mysql_error());
$row_rsSubmenu6 = mysql_fetch_assoc($rsSubmenu6);
$totalRows_rsSubmenu6 = mysql_num_rows($rsSubmenu6);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu7 = "SELECT * FROM sideindhold WHERE mainid = 7";
$rsSubmenu7 = mysql_query($query_rsSubmenu7, $cms) or die(mysql_error());
$row_rsSubmenu7 = mysql_fetch_assoc($rsSubmenu7);
$totalRows_rsSubmenu7 = mysql_num_rows($rsSubmenu7);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu8 = "SELECT * FROM sideindhold WHERE mainid = 8";
$rsSubmenu8 = mysql_query($query_rsSubmenu8, $cms) or die(mysql_error());
$row_rsSubmenu8 = mysql_fetch_assoc($rsSubmenu8);
$totalRows_rsSubmenu8 = mysql_num_rows($rsSubmenu8);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu9 = "SELECT * FROM sideindhold WHERE mainid = 9";
$rsSubmenu9 = mysql_query($query_rsSubmenu9, $cms) or die(mysql_error());
$row_rsSubmenu9 = mysql_fetch_assoc($rsSubmenu9);
$totalRows_rsSubmenu9 = mysql_num_rows($rsSubmenu9);
mysql_select_db($database_cms, $cms);
$query_rsSubmenu10 = "SELECT * FROM sideindhold WHERE mainid = 10";
$rsSubmenu10 = mysql_query($query_rsSubmenu10, $cms) or die(mysql_error());
$row_rsSubmenu10 = mysql_fetch_assoc($rsSubmenu10);
$totalRows_rsSubmenu10 = mysql_num_rows($rsSubmenu10);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "
http://www.w3.org/TR/html4/loose.dtd"><html>
<head>
<title>Administration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {
color: #666666;
font-weight: bold;
font-size: 12px;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
</head>
<body>
<table width="100%" border="0" class="layout">
<tr>
<td colspan="2" class="top style1"><div align="center">
<h2>Administrationsområde</h2>
</div></td>
</tr>
<tr>
<td class="top1"> </td>
<td class="top1"><table width="100" border="0" align="right" cellpadding="2" cellspacing="0">
<tr>
<td><div align="center"><strong><a href="<?php echo $logoutAction ?>">Log ud</a> </strong></div></td>
</tr>
</table></td>
</tr>
<tr>
<td class="left"><p> </p>
<p align="center"><strong>Admin-forside</strong></p>
<p align="center"><a href="code.php">Skift password</a> </p>
<p align="center"><a href="email.php">Skift emailadresse </a></p></td>
<td class="middle"><p> </p>
<table width="700" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="5" bgcolor="#CCCCCC"><div align="center">Rediger webstedet ved at vælge mellem følgende funktioner: </div></td>
</tr>
<tr>
<td><div align="center"><a href="admin_edit_topmenu.php?id=1">Forside</a></div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=2">Menu 2 </a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=3">Menu 3 </a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=4">Menu 4 </a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=5">Menu 5 </a> </div></td>
</tr>
<tr>
<td><div align="center"><strong>Undermenu</strong><br>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><div align="center"><a href="admin_edit_submenu.php?id=<?php echo $row_rsSubmenu1['id']; ?>"><?php echo $row_rsSubmenu1['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu1 = mysql_fetch_assoc($rsSubmenu1)); ?>
</div></td>
<td><div align="center"><strong>Undermenu</strong><br>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><div align="center"><a href="admin_edit_submenu.php?id=<?php echo $row_rsSubmenu2['id']; ?>"><?php echo $row_rsSubmenu2['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu2 = mysql_fetch_assoc($rsSubmenu2)); ?>
</div></td>
<td><div align="center"><strong>Undermenu</strong><br>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><div align="center"><a href="admin_edit_submenu.php?id=<?php echo $row_rsSubmenu3['id']; ?>"><?php echo $row_rsSubmenu3['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu3 = mysql_fetch_assoc($rsSubmenu3)); ?>
</div></td>
<td><div align="center"><strong>Undermenu</strong><br>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><div align="center"><a href="admin_edit_submenu.php?id=<?php echo $row_rsSubmenu4['id']; ?>"><?php echo $row_rsSubmenu4['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu4 = mysql_fetch_assoc($rsSubmenu4)); ?>
</div></td>
<td><div align="center"><strong>Undermenu</strong><br>
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><div align="center"><a href="admin_edit_submenu.php?id=<?php echo $row_rsSubmenu5['id']; ?>"><?php echo $row_rsSubmenu5['navn']; ?></a></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu5 = mysql_fetch_assoc($rsSubmenu5)); ?>
</div></td>
</tr>
<tr>
<td><div align="center"><a href="admin_new_submenu.php?id=1">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=2">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=3">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=4">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=5">Tilføj undermenu</a> </div></td>
</tr>
</table>
<form name="form1" method="post" action="">
<table width="700" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><a href="admin_edit_topmenu.php?id=6">Menu 6</a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=7">Menu 7</a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=8">Menu 8</a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=9">Menu 9</a> </div></td>
<td><div align="center"><a href="admin_edit_topmenu.php?id=10">Menu 10</a> </div></td>
</tr>
<tr>
<td><div align="center"><strong>Undermenu</strong></div>
<?php do { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><?php echo $row_rsSubmenu6['navn']; ?></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu6 = mysql_fetch_assoc($rsSubmenu6)); ?></td>
<td><div align="center"><strong>Undermenu</strong></div>
<?php do { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><?php echo $row_rsSubmenu7['navn']; ?></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu7 = mysql_fetch_assoc($rsSubmenu7)); ?></td>
<td><div align="center"><strong>Undermenu</strong></div>
<?php do { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><?php echo $row_rsSubmenu8['navn']; ?></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu8 = mysql_fetch_assoc($rsSubmenu8)); ?></td>
<td><div align="center"><strong>Undermenu</strong></div>
<?php do { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><?php echo $row_rsSubmenu9['navn']; ?></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu9 = mysql_fetch_assoc($rsSubmenu9)); ?></td>
<td><div align="center"><strong>Undermenu</strong></div>
<?php do { ?>
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td><div align="center"><?php echo $row_rsSubmenu10['navn']; ?></div></td>
</tr>
</table>
<?php } while ($row_rsSubmenu10 = mysql_fetch_assoc($rsSubmenu10)); ?></td>
</tr>
<tr>
<td><div align="center"><a href="admin_new_submenu.php?id=6">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=7">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=8">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=9">Tilføj undermenu</a> </div></td>
<td><div align="center"><a href="admin_new_submenu.php?id=10">Tilføj undermenu</a> </div></td>
</tr>
</table>
</form> <p> </p>
<table width="700" border="0" cellspacing="0" cellpadding="2">
<tr>
<td colspan="2" bgcolor="#CCCCCC"><div align="center">Administrér billeder: </div></td>
</tr>
<tr>
<td><div align="center"><a href="#" onClick="MM_openBrWindow('upload.php','upload','width=400,height=150')">Upload billeder</a> </div></td>
<td><div align="center"><a href="#" onClick="MM_openBrWindow('gallery.php','gallery','scrollbars=yes,width=500,height=500')">Vis / delete billeder </a></div></td>
</tr>
</table> <p> </p></td>
</tr>
</table>
</body>
</html>
<?php
mysql_free_result($rsSubmenu2);
mysql_free_result($rsSubmenu3);
mysql_free_result($rsSubmenu4);
mysql_free_result($rsSubmenu5);
mysql_free_result($rsSubmenu1);
mysql_free_result($rsSubmenu6);
mysql_free_result($rsSubmenu7);
mysql_free_result($rsSubmenu8);
mysql_free_result($rsSubmenu9);
mysql_free_result($rsSubmenu10);
?>