I have alogin table and added a expire date.
Once the user registers, the administrator puts in the user group to User, enabling him to see certain tables as set in the security permissions. I want the user's group to change to blank or say group: None once the expire dates becomes now() - today. Only when the user pays again, the admin will re-activate it by changing the group to User and set a new date.
Please help on how to achieve this.
In English:
Expire date newer or = to today - Usergroup = User
Expire date older than today - Usergroup change to None
An email sent to admin to confirm status changes of group from User to None, will be great.
Thanks for any help!