Update Usergroup using Php Script if email already exist

[kh99]

What you want to do is update the membergroupids field in the user table, where the email field matches the email address you have. The membergroupids field is a comma-separated list of integers (groupids), so you might be able to do it with one UPDATE query (which would probably need an "if" in the query because you'd need a comma or not depending on whether the membergroupids field is empty). If you wanted to do "right", you'd probably want to read the field, explode it in to an array, add "3" if it's not already in the array, then implode it back to a list and do an update. (I looked in to it before and found that the vb code is pretty forgiving of what's in that field, so you you wanted to just add 3 to the list without checking for it already being there, it should work anyway).