trouble MySQL AES_ENCRYPT() using PHP for SQL statement

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I want to add a binary element (AES_ENCRYPT()) to a $_POST array. I need to  
make it binary because it is going into a BLOB field.

$results = $dbr->Execute('select * from table1 where id='.$_GET['id']);
// validation take place and now is processed
$_POST["field1"] = $dbr->GetOne('select  
AES_ENCRYPT('.trim($_POST['field1']).', 'salt*&)#')');
// there are other $_POST fields that are in cluded in the next line
// GetInsertSQL is a function that eventually calls $dbr->Execute()
$dbr ->GetInsertSQL($results, $_POST, true);
It decrypts most records (field1) but not all. After researching it, I think  
the problem lies in how I am adding the encrypted field.

I think I need to make the $_POST["field1"] binary, somehow.

If so, how do I do that?

Any other ideas?

(the $dbr is an ADODB element.)  

Site Timeline