¡@
php Programming Glossary: t_categoriesGetting a modified preorder tree traversal model (nested set) into a <ul> http://stackoverflow.com/questions/1310649/getting-a-modified-preorder-tree-traversal-model-nested-set-into-a-ul all children of parent query SELECT max rght as max from t_categories row C_DB fetchSingleRow query max row max result ul query SELECT.. query max row max result ul query SELECT from t_categories where lft 0 and rght max if rs C_DB fetchRecordset query p_right.. so MySQL here as it was the first at hand CREATE TABLE t_categories` `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT `title` VARCHAR..
mySQL query for selecting children http://stackoverflow.com/questions/609328/mysql-query-for-selecting-children table and column name change . Expansion of explanation... t_categories as it stands now ... Cat Parent CategoryName 1 NULL MyStore.. 4 1 Books 5 2 Televisions 6 2 Stereos 7 5 Plasma 8 5 LCD t_categories after modification ... Cat Parent CategoryName Depth Breadcrumb.. 2 Stereos NULL NULL 7 5 Plasma NULL NULL 8 5 LCD NULL NULL t_categories after use of the script I gave Cat Parent CategoryName Depth..
|