problem with RULEs

Hi!

I don't know if this can be done with RULES or i have to use
FUNCTIONS.

I have table categories with colums

id,parent,name,cats

this is some data

1 | 0 | cat1 | 3
2 | 0 | cat2 | 1
11 | 1 | cat3 | 1
12 | 1 | cat4 | 0
21 | 2 | cat5 | 0
111 | 11 | cat6 | 0

cats colum mean how mani categories are inside some category,
U can see that cat1 have 3 sub cats, one is also sub ob
category cat3. This column is like totalsub category.

Now i want create rule on insert. When i create new category
i want that this cats would get automaticaly increased in all
required rows.

For example if i insert category

INSERT categories (id,parent,name,cats) VALUES (112,11,cat7,0)

I would like to increase by one in cat3 and also in cat1.

I've make some rule to increase oly parent category but where
i try create new rule to update all subs i have error msg

query rewritten 10 times, may contain cycles

I think i've done something wrong.

Can somebody help me with this. What RULE to apply or maybe
this have to be done with function

--
tia,
Uros mailto:uros(at)sir-mag(dot)com