$query = "SELECT date, AES_DECRYPT('cardnumber1','jmbjd'),
AES_DECRYPT('cardnumber2','jmbjd'), AES_DECRYPT('cardnumber3','jmbjd'),
AES_DECRYPT('cardnumber4','jmbjd'), upload_type, z_errors, a_errors,
db_errors FROM customers WHERE refrence_number = '$refnum'";
If 'cardnumber1' is the name of the c
Hey,
I am currently having alot of trouble using the AES_DECRYPT function. Can anyone
explain to me where I am going wrong. I can get the inserts to work, but I cannot
retrive the decoded string with the following Select statement:
$query = "SELECT date, AES_DECRYPT('cardnumber1','jmbjd'),
AES_D