Hi, I'm building a site where users can register and place an advert in four different categories.

What I want to do is limit the number of adverts they place in each category to 30.

I have a column in each table called count, every time the user insets an advert I want it to add one more to that users total.

I know there is a command procedure but I don’t know how to use it or what the SQL would be, could someone please tell me how to go about this.

Thanks in advance

Wayne