order child below the parent in mysqli

Solutions on MaxInterview for order child below the parent in mysqli by the best coders in the world

Search
showing results for - "order child below the parent in mysqli"
Syrine
18 Jan 2020
1# If no-parent = 0 instead of null 
2SELECT CONCAT(IF(parent = 0,'',CONCAT('/',parent)),'/',id) AS gen_order
3FROM table 
4ORDER BY gen_order
5
6#and if no-parent = null
7ORDER BY COALESCE(parent, id), parent IS NOT NULL, id
source
similar questions
parent and child link in mysqlhow to get parent and child record in single query using sqlmysqli query order by before group by
queries leading to this page
list tables in sorted order parent to chiled mysqlorderby parent childrenorder child below the parent in mysqliorder child below the parent in mysqli