Syntax Error

[kamloops]

Hi there,

Can anyone tellme what the syntax error is in this code:

$db->query("UPDATE user SET status = 'Y', extend = 'N', expiration_date = DATE_ADD(now(), INTERVAL $res2[months] MONTH), paypal_transaction_id = '$transaction_id[$value]' WHERE user_id = '$value'");

Thank you

 

[KarveR]

$db->query("UPDATE user SET status = 'Y', extend = 'N', expiration_date = DATE_ADD(now(), INTERVAL '$res2[months]' MONTH), paypal_transaction_id = '$transaction_id[$value]' WHERE user_id = '$value'");

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.