usergroup status equals profile option setting

[stuartn]

Okay need a little help working this out.

In Profile Options I have an option only viewable if a member of a certain subscribed group. But when the subscription runs out and the member doesn't renew that option will remain switched 'Off'. when it needs to be reverted back to the default 'On' position.

So I looked at the tables and the way I see it in the users we have the membergroup id's.

So what I need is some code that says 'where a member doesn't hold membergoupID = 10 for arguement sake then set userfield28 to 'On'.

Can anyone help me work this out.