hi, tried to use the encode and decode function in mysql.

i managed to encode my password but i have problems with decoding it.

my page requires user to login b4 they can browse the page. i didnt' manage to decode the password becos each time i login, it prompt me incorrect password.

this is how i encode and decode password:
update user set password = encode("joyce", "abc") where email = '$email'

SELECT decode("login_pass", "abc"), login_name FROM user where email = '$email'
pls advice..