jeeva Posted February 13, 2009 Share Posted February 13, 2009 Dear Frnds, I am in big trouble now, My Problem is i have a network table like below Uid | ParentId | Flag ------------------------------------------ Jeeva | Ajith | 1 (=>Right) john | Ajith | 2 (=>Left) senthil | Jeeva | 2 mercy | Jeeva | 1 kahn | john | 1 smith | john | 2 So, the network will be like Ajith | / \ Jeeva John / \ / \ Mercy Senthil kahn smith Now i have to take ajith network as LEFT and RIGHT separately. so which way i have to right the query to get that network. I am not good with mysql query, Please help me out Thanks Jeeva Quote Link to comment Share on other sites More sharing options...
fenway Posted February 15, 2009 Share Posted February 15, 2009 Yikes... look at some dev resources on storing trees in mysql. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.