How can i get the navigation of category? plz

[web_designer_iq]

Hi,
I have the following fields in "Categories" table in MySQL:

cat_id: The category ID (0 is Main Category)
cat_title: The categoty title
subcat: It's for sub category.

for example:
I want to get The navigation for "IRAQ".

The navigation is:

News > Middle East > Arab Countries > IRAQ > Chlorine bombs kill 8 in Iraq

SQL Query:

CREATE TABLE `categories` (
  `cat_id` int(11) NOT NULL auto_increment,
  `title` varchar(50) default NULL,
  `subcat` int(11) default NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `categories` VALUES (1, 'News', 0);
INSERT INTO `categories` VALUES (2, 'Middle East', 1);
INSERT INTO `categories` VALUES (3, 'Arab Countries', 2);
INSERT INTO `categories` VALUES (4, 'IRAQ', 3);

😕 any help?!!

[tomhath]

You can't do it in one query. You'll need a loop to read each level until you get to category 0. What do you have so far in the php page?

[web_designer_iq]

Ok. But how can i do it please?

[web_designer_iq]

Up... 🙁

[Roger_Ramjet]

http://www.sitepoint.com/article/hierarchical-data-database