problems with login script

External Since: May 19, 2008 Posts: 2

Hi, I can't get this script to work.
I've used this exact script on other places and it works, but now i
get this error.

<code> Warning: mysql_fetch_array(): supplied argument is not a valid
MySQL result resource in C:\xampp\htdocs\uploads\login_script.php on
line 15 </code>

I can't see what is wrong.
Here is the script.

<code>
<?php
session_start();
$anvnamn = $_POST['usr'];
$losenord = $_POST['pwd'];

include "dbconnect.php";

$anv2 = mysql_real_escape_string($anvnamn, $dbconnect);
$los2 = mysql_real_escape_string($losenord, $dbconnect);

$sqlfraga = "SELECT anvnamn FROM administrator WHERE anvnamn = '" .
$anvnamn . "' AND losen = '" . $losenord . "'";
$res = mysql_query($sqlfraga, $dbconnect);

if($rad = mysql_fetch_array($res))
{
$_SESSION['logged_in_admin'] = true;
}
else
{
$_SESSION['logged_in_admin'] = false;
}
?>
<html>
<body>
<?php
if($_SESSION['logged_in_admin'])
{
echo("You are logged in");
include('index.php');

}
else
{
echo ("go away");
}
?>
</body>
</html>
</code>

External Since: May 19, 2008 Posts: 10

On May 19, 1:36 pm, wrote:
> <code> Warning: mysql_fetch_array(): supplied argument is not a valid
> MySQL result resource in C:\xampp\htdocs\uploads\login_script.php on
> line 15 </code>
>
> $res = mysql_query($sqlfraga, $dbconnect);
> if($rad = mysql_fetch_array($res))

When the query fails, mysql_query() returns false, which results in
the error message you wrote. I am not sure if this is the case in your
situation, because this would also print a warning. Check the output
of mysql_query() and use mysql_error() to get the error message.