fejl i linie 23 ?
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/webs/netfact/html/go/login/index.php on line 23Min kode:
<?php
include("top.php");
$userName = $PHP_AUTH_USER;
require("settings.php");
require("functions.php");
connect_db();
$uQ = mysql_query("SELECT * FROM users WHERE USERNAME = '$userName'");
$thisUser = mysql_fetch_assoc($uQ);
$uID = $thisUser['ID'];
?>
<p align=center>
<font size=3>Velkommen <b><?=$thisUser['NAME']?></b></font>
</p>
<p>
Her finner du en liste over de områdene du har tilgang til: </p>
<?
$katQ = mysql_query("SELECT * FROM categories");
while ($thisCat = mysql_fetch_assoc($katQ)) {
$showCat = false;
$catTxt = "<br><b>" . $thisCat['NAME'] . "</b><br>";
$katID = $thisCat['ID'];
$omrQ = mysql_query("SELECT areas.NAME as NAME, areas.FOLDER as FOLDER FROM areas inner join area_users on areas.ID = area_users.AREA WHERE area_users.USER = $uID and areas.CATEGORY = $katID");
while ($thisOmr = mysql_fetch_assoc($omrQ)) {
$showCat = true;
$catTxt .= " <a href='" . $thisOmr['FOLDER'] . "'>" . $thisOmr['NAME'] . "</a><br>";
}
if ($showCat == true) {
echo $catTxt;
}
}
echo "<br>";
$omrQ = mysql_query("SELECT areas.NAME as NAME, areas.FOLDER as FOLDER FROM areas inner join area_users on areas.ID = area_users.AREA WHERE area_users.USER = $uID and areas.CATEGORY is null");
while ($thisOmr = mysql_fetch_assoc($omrQ)) {
echo "<a href='" . $thisOmr['FOLDER'] . "'>" . $thisOmr['NAME'] . "</a><br>";
}
if ($thisUser['ADMIN'] == 1) {
echo "<br><a href='admin'><u>Administrasjon</u></a>";
}
?>
Jeg kan ikke finde fejlen?
Hjælp mig gerne?
