Latest News: (loading..)

Archived

This topic is now archived and is closed to further replies.

letom

Selecting root category

2 posts in this topic

can any one suggest for the SQL query to select the root category(First level category) only

Share this post


Link to post
Share on other sites

Root level category is any category with parent_id = 0 in table CATEGORIES

Share this post


Link to post
Share on other sites