Data Assist update record with AES_ENCRYPT?
I am trying to add AES_ENCRYPT to the "busNum" field in the snippet of code below generated by Data Assist update record:
------
$WA_fieldNamesStr = "cartoff|busCardName|busCard|busNum|busXmon|busXyear|busCode|busCardReset|payUpdate";
$WA_fieldValuesStr = "" . "|" . "".((isset($_POST["busCardName"]))?$_POST["busCardName"]:"") ."" . "|" . "".((isset($_POST["busCard"]))?$_POST["busCard"]:"") ."" . "|" . "".((isset($_POST["busNum"]))?$_POST["busNum"]:"") ."" . "|" . "".((isset($_POST["busXmon"]))?$_POST["busXmon"]:"") ."" . "|" . "".((isset($_POST["busXyear"]))?$_POST["busXyear"]:"") ."" . "|" . "" . "|" . "" . "|" . "";
$WA_columnTypesStr = "',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''|',none,''";
$WA_comparisonStr = "=|=|=|=|=|=|=|=|=";
-------
I saw a previous post that said to try the following but it returns an error so the syntax must be wrong:
((isset($_POST["busNum"]))?AES_ENCRYPT($_POST["busNum"], 'encryptkey'):"")
I am using PHP & MySQL
Any help would be GREAT!