[SOLVED] Problem with verification script

[darkenedember]

Hello.

 

I am currently making a login panel for my site, but I cannot seem to get a script to work. I have, with a bit of testing, found the location of the error, but cannot understand what it is.

 

<?php
require('config.php');
mysql_connect($config['dbhost'],$config['dbuser'],$config['dbpass']);
@mysql_select_db($config['dbname']) or die("could not connect");
$username = $_POST['username'];
$password = $_POST['password'];
$hash1 = md5($password);
$hash2 = sha1($hash1);
$table = $config['dbprefix'] . "adminlogin";
$query = "SELECT password FROM " . $table . "WHERE username=" . $username;
$result = mysql_query($query);
if ($result == $hash2) {
$cookievalue = [color=red]<deleted value>[/color];
setcookie("asadmin", $cookievalue, time()+3600);
header('Location: [color=red]<url deleted>[/color]');
} elseif ($result == NULL) {
echo "null"; 
} else {
die("INVALID PASSWORD");
}
?>

 

I have, with the inclusion of that elseif, found that the query will not return a value. Could somebody please point out what I am doing wrong?

 

Thank you, and I am sorry if this is in the wrong section.

[ratcateme]

you need a space before the WHERE try adding "or die(mysql_error());" after your query

 

Scott.

[F1Fan]

Also, you should have single quotes around the username variable in the query if it's text.

[darkenedember]

Thank you both for the help. The double quotes thing helped alot, and so did the mysql_error() function.