I also posted this at sitepoint, not sure where to look for help!
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:<br>" . mysql_error() . "<br>" . 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:<br>" . mysql_error() . "<br>" . 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:<br>" . mysql_error() . "<br>" . mysql_errno());


Thanks
Nick

i think this is a php problem, the php interface can execute only one SQL statement at a time

i think

in any case you should really be looking at implementing a database transaction for this process

As has been mentioned in the previous post this should be split into two separate UPDATE statements and use a transaction to keep consistency. So this would be done with:

The try/catch has been added to make sure that if the processing fails that the transaction gets rolled back to the state it was prior to starting the transaction.