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($query);
if($password == mysql_result($result,0,"password")){
$firstname = mysql_result($result,0,"firstname");
$lastname = mysql_result($result,0,"lastname");
session_start();
session_register ("email");
session_register ("firstname");
session_register ("lastname");
$HTTP_SESSION_VARS ["email"] = $email;
$HTTP_SESSION_VARS ["firstname"] = $firstname;
$HTTP_SESSION_VARS ["lastname"] = $lastname;
$page = "home.php";
}else{
$page = "fail.html";
}
header("Location: " . $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($query);
if($password == mysql_result($result,0,"password")){
$firstname = mysql_result($result,0,"firstname");
$lastname = mysql_result($result,0,"lastname");
session_start();
session_register ("email");
session_register ("firstname");
session_register ("lastname");
$HTTP_SESSION_VARS ["email"] = $email;
$HTTP_SESSION_VARS ["firstname"] = $firstname;
$HTTP_SESSION_VARS ["lastname"] = $lastname;
$page = "home.php";
}else{
$page = "fail.html";
}
header("Location: " . $page);
mysql_close();
?>

Thanks for any help