Warning: Supplied argument is not a valid MySQL result resource
Hej,Jeg er ved at lave en login check. Jeg bruger nedenstående kode:
<?
require_once('../include/globalconf.php');
require_once('../language/'.$gn['lang'] . '.php');
// MySQL Connexion
$conn_id = mysql_connect($gn['host'],$gn['user'],$$gn['pass']);
mysql_select_db($gn['db']);
$sql = mysql_query("SELECT nick,password FROM ".$gn['prefix']."_admins WHERE nick='$nick' AND password='$password'") or die(mysql_error());
$result = mysql_query($sql);
while($row = mysql_fetch_row($result)) {
$nick = $row['nick'];
$password = $row['password'];
}
if (!$PHP_AUTH_USER) {
header("WWW-Authenticate: Basic realm=\"".$gn['realm']."\"");
header("HTTP/1.0 401 Unauthorized");
echo $gn['no_enter'];
exit;
}
else {
if ($PHP_AUTH_USER != $nick || $PHP_AUTH_PW != $password) {
echo $gn['no_enter'];
exit;
}
}
?>
Men nu får jeg følgende fejl:
Warning: Supplied argument is not a valid MySQL result resource in d:\foxserv\www\geeknews\admin\index.php on line 9
Warning: Cannot add header information - headers already sent by (output started at d:\foxserv\www\geeknews\admin\index.php:9) in d:\foxserv\www\geeknews\admin\index.php on line 14
Warning: Cannot add header information - headers already sent by (output started at d:\foxserv\www\geeknews\admin\index.php:9) in d:\foxserv\www\geeknews\admin\index.php on line 15
Hvad kan der være galt?
