I have this mysql query (below) in php to compare password in my database. The script below is not working. Can someone kindly advice.
Thanx
$getUser = $loginConnector->query("SELECT * FROM cmsusers WHERE user = '".$_SESSION['user']."' AND pass = PASSWORD('".$_SESSION['pass']."') AND thegroup <= ".$group." HAND enabled = 1");
yes. everything looks ok, but when it comes to camparing passwords i get no output. is there any syntax error with the query line because i can't see any.