Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 04, 2012 06:05 AM by yrb.yogi
May 15, 2009 05:12 AM|LINK
i have a table name "Category" in mysql database.
the table has field (CategoryId,Name,ParentId) in this table parent id refer to same table's primary key (categoryid)...
how can i write the recursive query to retrive the data with parent info.......
May 15, 2009 11:03 AM|LINK
Please have look on following link
This link may help you to find solution
May 15, 2009 11:42 AM|LINK
i have already seen that link's content.....
is there any other way to do this.....
i cant getting that link's content...thts y..............................................
May 15, 2009 12:07 PM|LINK
As far as I know mysql does not support recursive query feature. if you are using PHP then instead of recursive query u can go for recursive function
$q="SELECT identity FROM entity WHERE identity= ANY (SELECT identity FROM entities_parent_child WHERE idparent=".$parent "'";
while ($row = mysql_fetch_array($query))
May 15, 2009 12:13 PM|LINK
Sorry i m using C# asp.net....any help regarding this....
Dec 04, 2012 06:05 AM|LINK
To Solve this issue, i have created one physical table & logic for recursive.