How to delete usergroup id

[dip1232001]

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

[Marco van Herwaarden]

Would be easier using PHP then trying to do this in a single MySQL query i guess.

[dip1232001]

see i am quite new in php and mysql so any kind of help will be use full if oyu kidly give a hint how to do this thank you ..

[dip1232001]

Can any one help me here i just wanna create a corn job to do this so it will require php i know.but if any one can give me any hint thank you

[Marco van Herwaarden]

Read from the database. Use explode() to turn the comma seperated list of membergroupids into an array. Remove the element you don't need anymore. Use implode() to turn it into a comma sepratd list again and write back to database.

[dip1232001]

thanks thank you very much i am giving it a try ....