Has anyone tried to create a tree-like structure in a mysql database?I'm trying to devise a way that I can create a production selection wizard that will operate a lot like a tree where as you progress through the questions, the system will narrow down your results.

My reason for using a mysql database is so that it can be updated easily, as opposed to hard-coding the info into various script files...

I'm thinking about the idea of using a node-based system, where there is a parent node, and either 0 or more child nodes. so, as you progress through the tree, you have 0 or more options at each "level."

Suggestions or tips on how to implement this? (I already have a generic database and some scripts as a start, but they are very basic and probably are not the most efficient methods. I'm concerned that after the tree accumulates lots of nodes, my current scheme will slow down).

Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum