Are you refering to the MySQL password encryption? This encrypts passwords as they are saved into the db, and must also be used when retrieving them.
eg. $result = mysql_query("INSERT INTO users (username, password) VALUES ('$username', password('$password')");
hope this helps