Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [jwalter] Update User Table: Edit Log

Here is the list of edits for this post
Re: [jwalter] Update User Table
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

Last edited by:

mglaspie: Oct 16, 2001, 9:59 PM

Edit Log: