Database update issue

[eluser]Unknown[/eluser]
I want to make an update statement like this
update groups set member_count = member_count+1 where group_id =1

Here I dont know how to set "member_count+1" , Could some one help me ...


Another issue I have is, I want to convert all db errors to exceptions or is there any way to catch error in controller?

[eluser]n0xie[/eluser]

Code:

UPDATE groups SET member_count = (member_count + 1) WHERE group_id = 1

...