http://www.wallpaperama.com/forums/breadcrum-modified-pre-order-tree-transversal-mptt-sql-query-t5865.html Subscribe and keep up to date with Breadcrum Modified Pre-order Tree Transversal MPTT SQL Query with the latest replies and comments from other people like you who are interested in Breadcrum Modified Pre-order Tree Transversal MPTT SQL Query at wallpaperama.com en http://www.wallpaperama.com/forums/breadcrum-modified-pre-order-tree-transversal-mptt-sql-query-t5865.html $sql = &quot;SELECT C.* from myp1_category AS B, myp1_category AS C WHERE (B.category_left BETWEEN C.category_left AND C.category_right) AND (B.category_id = '12') ORDER BY C.category_left&quot;; i created this query because i wanted to know how i can get the breadcrum out of a Modified Pre-order Tree Transversal menu as shown here: http://www.wallpaperama.com/forums/mptt-modified-pre-order-tree-transversal-php-tree-menu-script-t5713.html so in keeping with this example. i want to show all the links for the bread yellow so it <a href="http://www.wallpaperama.com/forums/breadcrum-modified-pre-order-tree-transversal-mptt-sql-query-t5865.html">..... Read More </a> http://www.wallpaperama.com/forums/breadcrum-modified-pre-order-tree-transversal-mptt-sql-query-t5865.html Sat, 20 Feb 2010 18:22:09 -0800 No Comments have been submitted for this topic. Be the first to add your comments at www.wallpaperama.com http://www.wallpaperama.com/forums/breadcrum-modified-pre-order-tree-transversal-mptt-sql-query-t5865.html#