witam, mam taka tabelke:
[SQL] pobierz, plaintext 
  1. CREATE TABLE `kategorie` (  `category_id` smallint(6) NOT NULL AUTO_INCREMENT,  `parent_id` smallint(6) NOT NULL DEFAULT '0',  `category` varchar(255) collate latin2_bin NOT NULL DEFAULT '',  `slug` varchar(255) collate latin2_bin NOT NULL DEFAULT '',  UNIQUE KEY `category_id` (`category_id`),  KEY `parent_id` (`parent_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_bin AUTO_INCREMENT=11 ;INSERT INTO `kategorie` VALUES (1, 0, 0x6b617420676c6f776e61, 0x6b61742d676c6f776e61);INSERT INTO `kategorie` VALUES (8, 5, 0x737562206b61742032, 0x7375622d6b61742d32);INSERT INTO `kategorie` VALUES (7, 5, 0x737562206b61742031, 0x7375622d6b61742d31);INSERT INTO `kategorie` VALUES (4, 0, 0x746573746f77612d676c6f776e61, 0x746573746f77612d676c6f776e61);INSERT INTO `kategorie` VALUES (5, 1, 0x6b617465676f7269612031, 0x6b617465676f7269612d31);INSERT INTO `kategorie` VALUES (6, 1, 0x6b617465676f7269612032, 0x6b617465676f7269612d32);INSERT INTO `kategorie` VALUES (9, 6, 0x7375626262626231, 0x7375626262626231);INSERT INTO `kategorie` VALUES (10, 6, 0x62757575757373737331, 0x62757575757373737331);
[SQL] pobierz, plaintext
z zapytania chce uzyskac drzewko n-tej subkategorii... np.do where wrzucam parent_id=1 i chce otrzymac.. rekordy z ponizszej paczuszki:poziom 1: 1 \___ poziom 2: 5,6 \___poziom 3: 8,7,9,10... i tak az do koncaznalazlem...http://dev.mysql.com/tech-resources/articl...hical-data.html