Help.... heh heh
What would the mysql syntax be to select from the user base all users registered with the system prior to one month ago, and not a member of a specific group?
Ie. Registered over 30 days ago, and a member of the non-registered group.
Actually what I need to do here is everyone that logged onto the system prior to 30 days ago and has not paid their membership fees for the year need to be re-assigned from the member group to the expired group.
so whatever group(s) they're in say 3,5,7, needs to be changed to 3,7,8, type of thing.
Any one got any ideas?
