A relative easy question that I don't know the answer to: I'm trying to receive data from form fields and upload them into an sql table, but I've seen variations of sql UPDATEs and I don't know which kind to use.

on your first to options:
the first one just works with HTTP POST.. on one of my new servers just the HTTP_GET works. therefore the second query will function with both settings. the first query will just work with POST.

on the UPDATE field
the function intval() transforms the input into an integer value. the first example (Code #3) is for a string or text (thats also the reason you have the '" . $variable . "'

on your last two examples:
The second one (last code example from you) compares values /numbers. you do not need the little ' (do not know the english word) for it. the first one (second last code example) compares a string / text which requires the little '

I have a follow-up question though: I can't get checkbox values to be processed correctly. Originally selected values display fine, but subsequent changes which I UPDATE seem to override any future changes I make.

Working backwards, here's how my 3 checkboxes are assigned to the template:

Depending on which of the 4 methods above I use I sometimes get a debugging error regarding returned values of "on". Any ideas which way I'm supposed to code to receive checkbox values?

My customization is based on your existing coding and for these 3 values I noticed in "auction_offer" different references to the variables, like "offer_special" and "auction_offer_special". Am I perhaps supposed to use "auction_offer_special" all the time?

(I fixed an oversight on your "auction_store" pages with the radio buttons which weren't getting updated after selection - there, with yes/no radio buttons I can update intval selections but with intval checkboxes with 0/1 values like above I can't seem to get it)