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 Link to comment https://forums.phpfreaks.com/topic/145038-get-network-datas/ 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. Link to comment https://forums.phpfreaks.com/topic/145038-get-network-datas/#findComment-762697 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.