DECODE troubles

[bliss322]

$var = $db->get_var("SELECT DECODE(pwd, '".ENCRYPTION_KEY."') FROM userTables WHERE email = '".$email."'");
echo $var;

trying to use the above code to view onscreen the decrypted password. it does pull the data, but then it shows the still encrypted password?

any suggestions?

thanks

[LordShryku]

1) How are you storing the password? What kind of encryption?
2) What kind of database is this? Most databases use DECODE as an if/else operator, not an encryption scheme.