Server-side processing on data during initialisation

Server-side processing on data during initialisation

th-inkerth-inker Posts: 2Questions: 0Answers: 0
edited March 2010 in General
Combing through the discussions has yielded nothing, so I am hoping to word this thread such that others with my issue can find a solution.

I am pulling information from a database that contains encrypted data. I need to decrypt the data at some point between accessing th DB and initialising the tables so my agents can see the useful data.

Any ideas on running a php function in the initialisation code?

I have tried inserting it as follows with no luck:

$sOutput .= '"'.addslashes($aRow(text_decrypt['encryptedData'])).'",';

$sOutput .= '"'.addslashes($aRow[text_decrypt('encryptedData')]).'",';

I feel like the smarter solution is to write some code to redefine the actual data points, but I'm not sure where to start (ie:
$decryptedData = text_decrypt('encryptedData');
....
$sOutput .= '"'.addslashes($aRow['decryptedData']).'",';
)

The answer however should apply to anyone who is trying to run a function on any particular field of their tables.

-Thanks
This discussion has been closed.