Compare results from array

How do I compare results from a query array?
Alil insight to what I am trying to do. Pardon the ugly code, I have just begun.

$query0 = "select * from members whereusername = '$lusername' ";
$result1 = mysql_query($query0);
$row1 = mysql_fetch_array($result1);
$query1 = "select * from members where email = '$lemail' ";
$result2 = mysql_query($query1);
$row2 = mysql_fetch_array($result2);
print mysql_error();

if strcmp($row1[username] == $row2[username])
{redirect(); /* the redirect if above is correct */
}else{
print ("(try again)");
}
?>

There is most definitly an easier way to do this, but I havent a clue...
Uga

$query="select * from members where username='$lusername' AND email='$lemail'";
$result=mysql_query($query);
if (mysql_num_rows($result))
{
redirect();
}
else
{
print "(try again)";
}

From your code it looks like you are trying to verify that the record where username = $lusername and email=$lemail are the same. The above code will do this. If no rows are returned, then there was no match.

Thank you, that was alot simplier than I tried to make it.

Uga