Changing a profile field checkbox from vbadvanced

[Vitesse]

Thanks for replying rogersnm

Not exactly, i've made a module that had a submit button that when clicked I want to change the value of a custom field in the users profile (field 5).

What I really need to know is what I would need to do php wise to actually make the change to the profile as 'm assuming it'd be a mysql query which im not overly familiar with.

What the entire thing is supposed to do is:

1) If the user has already checked the box via there profile or clicked the button, then the template displalys they already are subscribed (nearly done that hopefully)

2)If the user clicks the subscribe button, profile field 5 is checked in their profile to see if it's already marked, if not then it marks it and saves the user profile. <---- This is what im totally stuck on