PHP Login

[Agent_Embryo]

I'm trying to figure out why this won't work...it's for a login system for the site I'm building...

[code]
$query = "select usrid, losen from tblUsers where usrid='$_POST[user]' and password='$_POST[pass]'" or die("Error in query");
$result = mysql_db_query($db, $query, $connection) or die("Error in query");
$myrow = mysql_fetch_array($result)

if ($myrow["usrid"] > 0) {
setcookie ("user", md5($myrow[usrid]));
setcookie ("pass", md5($myrow[losen]));
mysql_free_result($result);
header("Location: test2.php");
} else { $login_error= true; }
[/code

This is what generates the parse error...

if ($myrow["usrid"] > 0) {

Can someone help?

[vass0922]

are you sure you have a record?
Do a check to make sure that $result has a record before testing for a specific field.

[jkrohn]

are you sure you have a record?
Do a check to make sure that $result has a record before testing for a specific field.

If there was no result then mysql_fetch_array would throw an error. Evene if it *didn't* throw the error, PHP will just evaluate to NULL on a wrong index.

What exactly is the parse error.

Jkrohn