Code:
$user_links = $DB->table('PPC_Trans'); # first grab a new db handle $user_links->update ( {
Transaction_ID => $txn_id,
PayPal_Email => $payer_email,
Used => "1"
},
{
Date => $item_number
},
{
GT_SQL_SKIP_INDEX => 1
}
) or &error("Error: $GT::SQL::error");
OK, this may be off base, but there is something I don't like here,
about using the condition (especially) Date=>$item_number
This is not something that is guaranteed to be unique, and there
might be a problem in which record you are updating.
Could you be updating the record where Date=>$item_number, but it's
*not* the record you think you are updating?
Also, why is Date <=> $item_number ? Are you trying to obfuscate
your code <G>.
PUGDOG� Enterprises, Inc.
The best way to contact me is to NOT use Email.
Please leave a PM here.
