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_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'";
I am using the same exact key during the insert statement and my column is of blob
type.
Is my syntax wrong? Please help.
Thanks in advance.
JD
John A Della Pia
Intranet Application Developer
Systems Administrator
WiFiLand
877 WiFi LAND Ext.850
http://www.WiFiLand.net
Free to be...
