how to use crypt for login?

[hsceeus]

i doing a login page, and i want to encrypt the password that i already register... i can do that by using the crypt() function in PHP..

My problem now is how can i match the encrypt password in the database with the password that key in by user when they want to login to the page?

[omoutop]

//
// Taken from manual.
//
To authenticate against a stored crypt in MySQL, simply use:
SELECT ................
AND Password=ENCRYPT('".$_POST['password']."',Password)

[jatar_k]

just use md5() to encrypt the pass

then take the use input, md5 that and compare to the stored md5 string

[omoutop]

Jatar is correct, md5() offers better algorithm for encryption.

In md5 case you will have something like:
SELECT .. FROM.. WHERE ...
AND password=password('".$_POST['password']."')