Re: Help with AES_DECRYPT

2004-02-09 Thread Jigal van Hemert
$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

Help with AES_DECRYPT

2004-02-09 Thread John DellaPia
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