lupdate action erases variable data

[webguy262]

I added fields to the create_account form in CRE_LOADED/osCOMMERCE. The extra info goes into MySQL fine.

When a customer profile is viewed in the admin section, the extra fields are echoed out since there is really no need to change the data (it's stuff like 'How big is your company?" "How did you hear of us?")

There is an "Update" button on the page, however, in case something like name, email, address has to be updated. The problem is, when the Update button is clicked, the extra info data disappears.

Somehow, the Update action is wiping out whatever was entered into the additional fields.

Code is attached since it is long. TIA for any help!

[leatherback]

The only reason I can see is that the script uses $HTTP_POST_VARS which may cause trouble, but that would cause trouble throughout, and not just random fields.
The update uses ALL the userfields, so.. What do you mean with 'echoed out'? You somehow block them? You need all the info to be submitted, or you need to adjust the update query

[webguy262]

Yes, the update action in the admin view appears to be erasing the extra field data originally captured when the user creates an account. So I assume I need to modify the action so that it reenters this information. On the other hand, is there a way to modify the update action or update query so that it only updates the fields that are modify-able? That is, the fields that are displayed in input boxes. The extra fields I added are not displayed in input boxes. They are just displayed on the page by echoing the variables.

How would you recommend adjusting the update query?

[leatherback]

I have not enough insight in this code to see what other functions depend on it. But I would only update the colums that need updating

update TABLE (col=val), (col2=val2) where recordid=id