Rising Code Challenges

For the websites it is common to manage articles, products and much more thing by categories. And these categories have child categories and these child also have child and so in. So this article will show you that how to manage the Multi-level categories tree in PHP and MySql . First of all we need a Database table to store all categories. CREATE TABLE `tblcategory` ( `id` int(10) NOT NULL auto_increment, `pid` int(10) NOT NULL default '0', `title` varchar(255) NOT NULL, PRIMARY KEY (`id`) ); Multilevel categories tree in database table. Now time to get list of all categories with parent and their child, grand child and so on. There are two way to find all categories. 1. First solution that all knows, Recursion   In Recursion, first get all main parents categories and then start a loop and fetch all subcategories with their parent id's. function showCategories($cat_id = 0, $dashes = ''){ $dashes .= '--'; ...