Anyone?
$user_links = $DB->table('PPC_Trans'); # first grab a new db handle
$user_links->update ( { Transaction_ID => $txn_id,
isUsed => "1",
PayPal_Email => $payer_email },
{ SetID => $item_number },
{ GT_SQL_SKIP_INDEX => 1 } ) or &error("Error: $GT::SQL::error");
I'm going to try it on another server, in case it is something to do with that...but I can't do that until my new server comes online...
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Code:
# ok, everything seems fine here, lets update the database, and also prefix_Users with their new purchase... $user_links = $DB->table('PPC_Trans'); # first grab a new db handle
$user_links->update ( { Transaction_ID => $txn_id,
isUsed => "1",
PayPal_Email => $payer_email },
{ SetID => $item_number },
{ GT_SQL_SKIP_INDEX => 1 } ) or &error("Error: $GT::SQL::error");
I'm going to try it on another server, in case it is something to do with that...but I can't do that until my new server comes online...
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!