Auyon Bhattacharya wrote:
I am new to this. I have been trying to implement a hierarchial data structure in Mysql 5.0, on Windows NT with PHP. Can anyone tell me if I wish to retrieve an information such as the list of fore-fathers from a family tree how do I go about it in MySQL. I think MySQL still do not have support for Hierarchial Queries. ( like in Oracle we have CONNECT BY PRIOR) . Can I use functions to get a array of names or something like that. Or is there any other owrk around for it.
PLEASE HELP. Auyon Bhattacharya. Birla Institute of Technology, Mesra,India.
Have a look at excellent tutorial: http://www.sitepoint.com/article/hierarchical-data-database
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
