· 7 years ago · Sep 08, 2018, 05:10 PM
1Category Hierarchy (in order) using PHP MySQL
2CREATE TABLE IF NOT EXISTS `categories` (
3 `category_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
4 `position` smallint(5) unsigned,
5 `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0'
6 PRIMARY KEY (`category_id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;