dip1232001
09-03-2008, 03:39 AM
How to delete usergroup id from user table for a specific user ..
I mean i need a mysql query to delete a vip userid if he or she's subscription is cancelled..
so i have to remove the specific usergroup id from mysql--->my database--->specific user table..
can any one hel please ...
thank you
suppose vip usergroup id= 49
and user's main usergroup id = 5
and in membergroupids =49,50,89
The 49 is inserted in membergroupids as he have purchased the subscription.
now when ever the susbcription is cancelled which query should be done to delete 49 from his
membergroupids
:D:D
I mean i need a mysql query to delete a vip userid if he or she's subscription is cancelled..
so i have to remove the specific usergroup id from mysql--->my database--->specific user table..
can any one hel please ...
thank you
suppose vip usergroup id= 49
and user's main usergroup id = 5
and in membergroupids =49,50,89
The 49 is inserted in membergroupids as he have purchased the subscription.
now when ever the susbcription is cancelled which query should be done to delete 49 from his
membergroupids
:D:D