Dear all For a documentation system we have a tree structure of key words (came from an excel file).
it's now in a MySQL table with the following columns (field names are pretty self-explanatory) CREATE TABLE IF NOT EXISTS `keywords` ( `id` smallint(5) unsigned NOT NULL auto_increment, `parent_id` int(10) unsigned default NULL, `keyword` varchar(64) collate utf8_unicode_ci NOT NULL, `approved` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) keywords at root level have parent_id NULL. I want to have a system so each keyword can display its chain of parents up to the root level For example I have this chain: "Nature sciences" -> "chemistry" -> "analysis methods" -> "gas analysis" When I view keyword "gas analysis" I want my code to display: Parent chain : "Nature sciences" -> "chemistry" -> "analysis methods" When I follow the procedure as described here: http://bakery.cakephp.org/articles/view/threaded-lists I can't get it to work. I keep getting the error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'findAllThreaded' at line 1 For some reason the function name findAllThreaded is passed as a SQL statement :s Can anyone please advise? I use CakePHP 1.3 Best regards, Marvelade Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
