Can someone see what is wrong with this query? I receive my error message ‘can not execute’ . I believe it to be a syntax error.

$sql = "SELECT * FROM users WHERE email='$email' AND password ='$password'";

//execute query
$rs = mysql_query($sql,$connection) or die("can not execute");

$abs = mysql_fetch_array($rs) ;

Replace the 'can not execute' string with a call to mysql_error() to receive a more detailed message.

 ... or die('Error: ' . mysql_error());

Thanks, it gave me the answer. Bad db name, typo