encode && decode
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'