scraptoft Posted June 22, 2006 Share Posted June 22, 2006 I am trying to create a navigation bar which will echo all of the categories in the database.I want the navigation bar to show like below:Category1-subcategory-subcategory-subcategoryCategory2-subcategory-subcategoryCategory3-subcategory-subcategory-subcategory-subcategoryHeres my code to query Category:[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]$query_category = "SELECT name FROM webstructure where level = '2'"; $result_level = mysql_query($query_category) or die("Invalid query: " . mysql_error()); while ($row=mysql_fetch_array($result_lcategory2)) { $name = $row['name'];[/quote]This echos like:Category1Category2Category3I cannot figure out how to echo the correct [b]Subcategory[/b] underneath it's speficific [b]Category[/b]. Does anyone have any ideas how to do this, or what functions to use?Thankyou for your time Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/ Share on other sites More sharing options...
trq Posted June 22, 2006 Share Posted June 22, 2006 Depends on how your data is related really. More than likely you would need to use recursion.can we see your table schema? Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48312 Share on other sites More sharing options...
scraptoft Posted June 22, 2006 Author Share Posted June 22, 2006 My category table is like so.Name [name of category or subcategory]parent_category [if its a subcategory the parent name is here]level ['1','2','3'] [different levels to show on each page]After writing this out, i'm starting to think I need to make changes to my table. Or can I get away with it this way?Cheers for your fast reply. Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48317 Share on other sites More sharing options...
trq Posted June 22, 2006 Share Posted June 22, 2006 You could get away with it but there are better ways to represent hierarchical data. Maybe [a href=\"http://www.phpriot.com/d/articles/php/application-design/nested-trees-1/index.html\" target=\"_blank\"]this[/a] tutorial will help. Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48322 Share on other sites More sharing options...
scraptoft Posted June 22, 2006 Author Share Posted June 22, 2006 I'm still trying to learn PHP but could do with this project finished (it doesn't have to be perfect) so I can get onto studying the language more. Could you give me a few pointers on how I could get away with it.p.s thanks for the tutorial I will deffinatly read it more indepth in the morning. Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48327 Share on other sites More sharing options...
scraptoft Posted June 22, 2006 Author Share Posted June 22, 2006 [b]b[/b]u[b]m[/b]pAnyone can shed some more light on this problem? Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48473 Share on other sites More sharing options...
freakus_maximus Posted June 22, 2006 Share Posted June 22, 2006 Check out my post here:[a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=94066&st=0&p=376462&#entry376462\" target=\"_blank\"]Catagories and Subcatagories[/a]This has helped a few others out and should get you going the way you want. Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48502 Share on other sites More sharing options...
scraptoft Posted June 22, 2006 Author Share Posted June 22, 2006 Cheers mate, i'm finding that post very helpful. I'm 80% to the way I want it, another hour or so and it should be working great.Cheers guys Link to comment https://forums.phpfreaks.com/topic/12601-php-navigation-for-cms/#findComment-48527 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.