I use the mysql PASSWORD() function in my code like this:
$sql = "SELECT username, uid
FROM users
WHERE username = '$userId' AND password = PASSWORD('$password')";
Can you use this in xampp? I'm just wondering because somehow it's not working right and I was wondering if this should work properly in xampp.