mySQL PASSWORD function

[TouchTheClouds]

how does it exactly work?

i try to use it like this:

mysql_query("insert into blabla set login = '$login', password = PASSWORD('$pass')");

but when i try
mysql_query("SELECT * from blabla WHERE login = '$login' AND password = PASSWORD('$pass')");
it always return mysql_num_rows = 0 🙁

[blacktiger]

if your using PHP, then i wouldn't recommend using mySQL to encrypt your passwords. PHP includes a function that will allow you to encrypt passwords through it. you can however use mySQL to encrypt functions, but then you must use mySQL to check the validity of a password as well.

to check if a password is correct, you must encrypt the submission, then check if it is the same as the encrypted data in the database. I believe it's something like this

$result = mysql_query("SELECT FROM members WHERE username='" . $user . "' AND password=PASSWORD('" $pass . "');");

that should work, but it really depends on what ur wanting to use passwords for, and how your database is setup.

[TouchTheClouds]

I use these passwords for php sessions.