How to get category entries along with category subcategory entries via relations?

M

Melodic2014-08-29 21:33:50

MySQL

Melodic, 2014-08-29 21:33:50

Is Category(id,name,parentCategoryId)
Is Object(id,name)
Object and category are related MANY_MANY.
How to get category objects including subcategory objects?
For example, if the id of the root category is specified, then select ALL objects.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Maxim Grechushnikov, 2014-09-02
@maxyc_webber

use nested sets