Taking variables passed, then add to DB

[Anon]

Hi all,

perhaps I should be at the SQL site, but I figured to two go hand in hand quite a bit, so I'll try here first!

So here is the deal...I get return values from my credit card processor, I need these variables to be passed to the MySQL DB that I have on already set up on the site.

Can I get a snippit or someting?

Here it the variable the credit card co. gives me:
amount

I need that variable to be renamed to:
account_balance

but still keep the value (i.e $4.95)

and then update the mySQL DB with that info.

Preferable, this would be done on the fly, but if it needs to be passed to a PHP page that the client submits, that would be fine too!

Thanks in advance!

Matt

[jc94062]

"Here it the variable the credit card co. gives me:
amount

I need that variable to be renamed to:
account_balance"

$account_balance = $amount;
//amount and account_balance now hold the value that amount used to hold

"then update the mySQL DB with that info."

To update the db via PHP...

$query = mysql_query("update table_name set field_name='$val', field2='$otherval' where something='$variable'");

Hope that helps