Thank you guys in advance! i am desperately need to display my data in this way,
My database structure is,
Column idcat, parent_id and child_id is sharing single column name, catname.
I tried to write my own query,
SELECT idcat, parent_id`, child_id, catname, catDesc, catstat, del_cat (SELECT catname WHERE parent_id=idcat FROM categories ) as parent, (SELECT catname WHERE child_id=`parent_id FROM categories) as child FROM categories
I hope you can help me guys! thank you!