I don't have a background in CS or data structures. I want to make a PHP class that stores a modified preorder transversal tree, for manipulation and syncing with a database. Basically I need to ...

I have this table: CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `category_id` int(11) default NULL, `root_id` int(11) default NULL, `name` varchar(100) collate utf8_unicod...

What are 'best-practices' for saving Composite patterns in a Relational Database? We have been using Modified Preorder Tree Traversal. This is very quick to build the whole tree, but very slow to ...