Hello Rich,
On 8/27/2012 12:19 PM, rich gray wrote:
Hi Nitin
Thanks - I tried that and got 0 rows...
I have spent more time on describing my problem -- see below hopefully
this will make the issue more clear...
Rich
... snip ...
There are many resources out there that can tell you how to build this
type of data structure. However, my favorite and the one I think is most
accessible is this:
http://www.sitepoint.com/hierarchical-data-database/
As you can see, his menu also has branches (fruit) and leaves (cherry,
banana) just as your equipment menu does. I think this will be an
excellent starting point for you to use to build the menu tree. From
there, it should be easy to extend this to link your leaf nodes to any
information records you may want.
Let us know if we can give any additional insights or suggestions.
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql