[RESOLVED] Storing field into Mysql

[teamfox20]

Hi there,

I am working with a credit card form that submits the info to Authorize.Net using a secured .dll file. The dll file responds with | delimited information which looks like this:

1|1|2|Approved|||||||||First Name|Last Name| Address| City|State|||||

I have it broken down to capture the data but how can i store a specific field after the transaction is approved. I want to be able to store the Approved response in mysql

I can echo the Approved message into a textbox but the screen is just a receipt page that does not require a users input where i would be able to update record via a form.

[Scriptmaker]

maybe the php function explode
explode the string by the | delimiter and then strip empty values.

for the first row, have it store each of the values as strings with the same name as the value, ie $lastname = $exploded[6];

then, as it loops through the remaining rows that actually contain the data, exploding each line and creating a new array, have it store each of the keys of that array into the database using the variables you set up with the first row.

Just throwing out an idea, I'll try to put some code together later if you're still having trouble.