Multiple updates

Oldnickj · January 4, 2011, 10:07pm

Apologies for my lack of scripting skills. I’m trying to adapt a PayPal IPN script to update several tables in one go.

This script works fine: $strQuery2 =

“UPDATE user_usr
SET amt_paid_usr='”.$mc_gross.“’
, paypal_usr='”.$txn_id.“’
, paymentdate_usr='”.$fecha.“’
WHERE invoice_usr='”.$custom.“'”;
"

$result = mysql_query($strQuery2) or die(“Subscription - paypal_subscription_info, Query failed: ” . mysql_error() . “ ” . mysql_errno());

When adding a second query it fails:

“UPDATE user_usr
SET amt_paid_usr='”.$mc_gross.“’
, paypal_usr='”.$txn_id.“’
, paymentdate_usr='”.$fecha.“’
WHERE invoice_usr='”.$custom.“'”;

“UPDATE transactions
SET amt_paid_trn='”.$mc_gross.“’
, paypal_usr='”.$txn_id.“’
, paymentdate_trn='”.$fecha.“’
WHERE '”.$item_name.“’
LIKE ‘%G%’ AND gifter_trn='”.$custom.“'”;

$result = mysql_query($strQuery2) or die(“Subscription - paypal_subscription_info, Query failed: ” . mysql_error() . “ ” . mysql_errno());

I also tried to enclose in quotes rather than two separate sets:

$strQuery2 = “UPDATE user_usr
SET amt_paid_usr='”.$mc_gross.“’
, paypal_usr='”.$txn_id.“’
, paymentdate_usr='”.$fecha.“’
WHERE invoice_usr='”.$custom."';

UPDATE transactions
SET amt_paid_trn=‘“.$mc_gross.”’
, paypal_usr=‘“.$txn_id.”’
, paymentdate_trn=‘“.$fecha.”’
WHERE ‘“.$item_name.”’ LIKE ‘%G%’
AND gifter_trn=‘“.$custom.”’";

$result = mysql_query($strQuery2) or die(“Subscription - paypal_subscription_info, Query failed: ” . mysql_error() . “ ” . mysql_errno());

system · January 4, 2011, 11:14pm

[fphp]mysql_query[/fphp] can run only 1 query at a time.

r937 · January 4, 2011, 11:25pm

and you should probably be using a database transaction for this process

system · January 4, 2011, 11:30pm

If your db doesn’t support transactions then you can undo the updates programatically from the application in the unlikely scenario an error occurs preventing all the updates from completing.