DES_DECRYPT() working on localhost, but not on the web-server

[eluser]tpetrone[/eluser]
Ok,

So based on your quest the DB is doing the encrypting/decrypting..

Code:

SELECT email, DES_DECRYPT(password) AS pass FROM user_table WHERE sec_q=’$sec_q’AND sec_a=’$sec_a’

Based on what I am seeing at this link ( http://www.w3resource.com/mysql/encrypti...rypt().php)

This should be something like..

Code:

SELECT email, DES_DECRYPT('mydecrypt_text', 'password') AS pass from ............

Hope this is helpful