Trouble with login page

[Shawn Northrop]

Hi,
I am having a few issues with a login script i have created.
If the username is not in the database it give me an error:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 2 in /home/jeannefl/public_html/players-vintage/load_login.php on line 8

heres my code:

$query = ("SELECT * FROM user WHERE email = \"". $email . "\"");
$result = mysql_query($qu ery);
if($password == mysql_result($r esult,0,"passwo rd")){
$firstname = mysql_result($r esult,0,"firstn ame");
$lastname = mysql_result($r esult,0,"lastna me");
session_start() ;
session_registe r ("email");
session_registe r ("firstname" );
session_registe r ("lastname") ;
$HTTP_SESSION_V ARS ["email"] = $email;
$HTTP_SESSION_V ARS ["firstname"] = $firstname;
$HTTP_SESSION_V ARS ["lastname"] = $lastname;
$page = "home.php";
}else{
$page = "fail.html" ;
}
header("Locatio n: " . $page);
mysql_close();
?>

Thanks for any help

[Motoma]

If I were to guess, your query returned no results.
I recently posted a tutorial on creating a data abstraction layer to assist with technical issues such as this, take a look if you continue to have troubles like this.

Hi,
I am having a few issues with a login script i have created.
If the username is not in the database it give me an error:

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 2 in /home/jeannefl/public_html/players-vintage/load_login.php on line 8

heres my code:

$query = ("SELECT * FROM user WHERE email = \"". $email . "\"");
$result = mysql_query($qu ery);
if($password == mysql_result($r esult,0,"passwo rd")){
$firstname = mysql_result($r esult,0,"firstn ame");
$lastname = mysql_result($r esult,0,"lastna me");
session_start() ;
session_registe r ("email");
session_registe r ("firstname" );
session_registe r ("lastname") ;
$HTTP_SESSION_V ARS ["email"] = $email;
$HTTP_SESSION_V ARS ["firstname"] = $firstname;
$HTTP_SESSION_V ARS ["lastname"] = $lastname;
$page = "home.php";
}else{
$page = "fail.html" ;
}
header("Locatio n: " . $page);
mysql_close();
?>

Thanks for any help