http://www.codeassembly.com/feed/comments/21 CodeAssembly - Simplicity is prerequisite for reliability - Comments en-us contact@codeassembly.com contact@codeassembly.com RSS Feed Generator Hi Need your some more help. This code works fine if one category is inserted only once. But how do we achieve if we insert category more than once. Like WebDevelopment HTML MISC HTML HTML1 HTML2 HTML3 Other HTML here HTML lies three times. If you have some time please help. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#399 2011-12-26 05:53:58 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#399 Hi Thanks Codeassembly for such an easy code It works for Asp .net C# Tooo Thanks For ASP .net guys here is my code: Bind dataset or genric list with data and follow the code. string treeList = string.Empty; public string BindEmp(int ParentId) { Boolean hasChild = false; foreach (DataRow dr in ds.Tables[0].Rows) { if (ParentId == Convert.ToInt32(dr["projEmp_ParentEmpId"])) { if (hasChild == false) { hasChild = true; treeList += "

"; } treeList += "
• " + dr["empname"].ToString(); BindEmp(Convert.ToInt32(dr["projEmp_EmpId"])); treeList += "
"; } } if (hasChild == true) { treeList += "

"; } return treeList; } Hope this help someone. Thanks Anuj Koundal http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#398 2011-12-23 03:19:04 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#398 Works perfectly... one single query ... print all the categories and its subcategories(multiple level).. But if its a huge category list i wud rather cache the output in a file and fetch it from there, so that i dont have to use this function unless there was a change in the (CRUD operation done on the category table) categories list. thanks Arif http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#386 2011-09-14 06:22:32 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#386 very good example.i just want to add just two lines. 1. add id field also $menu_array[$row['id']] = array('name' => $row['name'],'parent' => $row['parent'],'link' => $row['link'],'id'=>$row['id']); 2. make it dynamic echo '

' . $value['name'] . ''; thanks http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#374 2011-06-30 19:53:46 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#374 Hi, this worked perfectly. can you tell me how to worked this with combobox?(dropdown) Thanks for any reply. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#361 2011-01-10 06:15:34 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#361 Hi, really nice code but I want a multi dimension array one row for one record. but I can't able to do this I am new in php can you help me. actually I want to show this data in a list format. regards, Mahi, http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#357 2010-12-18 02:45:46 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#357 Hi Thanks for sharing program.but how can i display all parent & child categories in dropdown with differentiation.. like Parent1
---Childparent1
Parent2
---Child1parent2
------childchild1parent2 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#342 2010-09-03 05:51:01 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#342 Is it possible, using this code, to output a categories and it's subCat based on a specific ID? Web Developement ID is 1. I want to fetch only Web Developement and it's child. How do I do that? Please help http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#309 2010-03-25 11:11:28 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#309 GReat piece of code. Tested with a very very large category table and things are little slow. However for my shop that has 4 levels of categories this is absolutely perfect. Thanks http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#294 2010-03-08 13:13:08 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#294 You have just solved my 2 day-old vb headache with that recursive function. Awesome job http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#293 2010-03-03 06:46:23 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#293 Great codes, I am really having a hard time displaying the cat subcat that I have in a way it will show up like a combo box. Thank you! http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#273 2009-11-20 23:58:48 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#273 Hi, thanks so much for this code; I am writing a file manager component for Joomla and I couldn't figure out how to manage unlimited sub-categories cleanly, and with only using one database query. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#249 2009-07-13 01:59:25 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#249 Hy Barry, By "you need to select the rows inside the function instead of declaring the menu_array as a global" he means to remove global declaration of array from the function definition and pass it to the function as a argument. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#247 2009-07-01 05:58:12 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#247 Hi, I enjoyed your tutorial. However with a category structure of up to 3000 different rows. The code does run slow. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#201 2009-02-12 04:30:44 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#201 Hi, Good Worked. I can\'t able to list the display in ul li order. with the help of your code, i can. Thanks http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#138 2008-07-06 03:46:39 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#138 Hi, I tried using a $var just replace "echo" in this function but can't. Help me because I am using Xtemplate for my project. Thanks http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#105 2008-05-01 14:22:23 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#105 Please provide an example of what you mean by "you need to select the rows inside the function instead of declaring the menu_array as a global." I have had the same issue with only one set of results being displayed. Thank you. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#104 2008-05-01 14:22:23 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#104 Hi, I tried using a $var just replace "echo" in this function but can't. Help me because I am using Xtemplate for my project. Thanks http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#101 2008-05-01 14:22:23 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#101 First - thanks for the tutorial. Mauro, I had the same problem (worked on one server but only first row shows on a different server). Can you explain what you mean by selecting the rows inside the function instead of declaring the menu_array as global? Thanks. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#100 2008-04-18 00:57:45 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#100 What about deleting? No one ever shows about deleting. I'm not talking DELETE WHERE id = $id AND parent = $id I'm talking if theres a Parent with a Child(1) that has a child(2) that has a child(3). If you delete the main parent how would it go about deleting all the way up to child 3 as child 2 is it's parent and child 1 is child 2's parent and parent is the parent of child 1. Hope I didn't confuse anyone. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#95 2008-05-01 14:21:24 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#95 This code is great. I'm using the one with CSS formatting, not the javascript expandable one. My problem is the category names are linked and I don't want them to be. I only want the subcategories to be linked. On this page, the example shows the categories as unlinked, but when I use the code, it makes my category names linked. Any ideas? http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#76 2008-03-21 14:02:43 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#76 Hi Mauro, I have the same problem as Jason but I dont understand you explination. What does this mean "you need to select the rows inside the function instead of declaring the menu_array as a global."? What does that mean? Which part of the script must I edit? Can you please give us an example. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#67 2008-03-21 14:02:43 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#67 Cheers Mauro - you are a star. It now works a treat :-)) http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#48 2007-11-26 07:50:36 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#48 Hi, the problem is that you need to select the rows inside the function instead of declaring the menu_array as a global. It should work after that. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#43 2007-11-26 07:31:52 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#43 Hi, Strange - I've also tried example above from Rik Moncur and it does exactly the same, works on one host but not another. Regards Jason http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#42 2007-11-26 07:32:56 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#42 Hi Jason, I had complains about this problem from other users, there is no php module requirement, I didn't discover the cause that is producing this problem. I just retested my script and it works fine, I'm using php 5.2.4 with apache on linux for my tests, but I think it works fine on older versions to. http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#41 2007-11-26 07:32:29 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#41 Hi, I have tried using the above on two different hosts - both are running php v5. On one host, the menu displays perfectly but on the other it only ever shows the first 'parent' and first 'child'. Is there a specific PHP Module that needs to be enabled for this menu to work? (hosts question not mine :-)) Many thanks Kind Regards Jason http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#39 2008-03-21 14:02:43 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#39 thanks for the clear way you have put this tut together. just the facts none of the crap. I like how you mainly focused on what we really want to know, the php http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#32 2007-11-12 07:31:30 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#32 The css version doesn't seem to function as per your example i.e. the first item in the menu has href link but should be just text? Hope that makes sense - great tutorial though :-) Regards Jason http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#16 2007-10-07 08:25:25 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#16 Thank you very much for your article. It helped me a lot! http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#14 2007-11-19 08:53:07 http://codeassembly.com/How-to-display-inifinit-depth-expandable-categories-using-php-and-javascript/#14