Hi,
You might try something like this:
Add this line:
my $update_db = $DB->table('Links','Users');
Then:
$update_db->update ( { Hits => \"Hits + 1", Total_Amount => \"Total_Amount + Rating", Deposit => \"Deposit - Rate"}, { ID => $id }, { GT_SQL_SKIP_INDEX => 1 } );
(With a relational query, I think you want to call the columns without the table name prefix.)
I'm not sure if this will work, but might be worth a try. This is untested, of course.
(Edit: deleted extra "Deposit =>" from code)
--
Matt G
You might try something like this:
Add this line:
my $update_db = $DB->table('Links','Users');
Then:
$update_db->update ( { Hits => \"Hits + 1", Total_Amount => \"Total_Amount + Rating", Deposit => \"Deposit - Rate"}, { ID => $id }, { GT_SQL_SKIP_INDEX => 1 } );
(With a relational query, I think you want to call the columns without the table name prefix.)
I'm not sure if this will work, but might be worth a try. This is untested, of course.
(Edit: deleted extra "Deposit =>" from code)
--
Matt G