Jump to content



Photo
- - - - -

Selecting root category


This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1   letom

letom
  • Members
  • 4 posts

Posted 30 July 2012 - 11:01

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

#2 ONLINE   multimixer

multimixer

    Lemons or Melons ?

  • Partner
  • 4,606 posts

Posted 31 July 2012 - 04:05

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