I can query my user table fine until I change the INSERT query to include PASSWORD('$password') function.
ie
$query = "insert into users (user_name, password ) values ('$name', password('$password'))";
So then my password is stored encrypted, and then my authentication query doesn't give true result. It returns false when data that is stored in the table is entered.
$query = "SELECT * FROM users
WHERE user_name='$user_name' AND password='$password'";
I'm now thinking something here needs to be changed for the query to give a true result against the encrypted field, but I can't find the info.
Does that make sense to anybody?
Thanks in advance