counting sub rows in mysql

Posted by moustafa on Stack Overflow See other posts from Stack Overflow or by moustafa
Published on 2010-03-27T09:27:40Z Indexed on 2010/03/27 9:33 UTC
Read the original article Hit count: 191

Filed under:

i have 2 table ok catgories and artilces i have this structure catgories

web > design > photoshop > layers
web > design > photoshop > effects

and each one is a catgory and layers catgories has 100 article and effects catgories has 50 article

now i want when count the articles 'web' catgory it show 150 article how i can do this give me an example

© Stack Overflow or respective owner

Related posts about mysql