Hi i have a breadbrumb system working for my category's and sub category's using this code
here is my table scheme for my category's tableCode:<?php $result = mysql_query("SELECT * FROM cats WHERE name='{$_GET['category']}'"); $info = mysql_fetch_array($result); $str = $info['name']; while ($info['parent_id'] != 0) { $info = mysql_fetch_array(mysql_query("SELECT * FROM cats WHERE id='".$info['parent_id']."'")); $str = $info['name']." > " .$str ; } echo "<p><a href=\"index.php\">Home</a>"; if (isset($str)) { echo " > $str </p>"; } else echo "</p> "; ?>
Code:
Code:`cats` ( `id` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', `parent_id` int(11) NOT NULL default '0', PRIMARY KEY (`id`)
and this is my table scheme for my tutorials
Code:
What i'd like is some advice how I would include pages into the breadcrumbCode:tutorials` ( `tutorialID` int(4) NOT NULL auto_increment, `tutorialTitle` varchar(255) NOT NULL default '', `tutorialDesc` text, `tutorialCont` text, `category` varchar(40) NOT NULL default '', `tutorialDate` timestamp NOT NULL default CURRENT_TIMESTAMP, `tutorialviews` varchar(30) NOT NULL default '0', PRIMARY KEY (`tutorialID`)
for example as the code stands i can navigate to home > windows xp > email >
but as soon as i click on a tutorial i lose the breadcrumb and just see home > as that part is static.
I know i need to change how the code is laid out but not sure what i need to do any advice would be very useful
cheers



Bookmarks