skomplikowane sortowanie

skomplikowane sortowanie

onlyX Zobacz profil	9.11.2005, 19:21:25 Post #1
Grupa: Zarejestrowani Postów: 119 Pomógł: 0 Dołączył: 15.07.2003 Skąd: Grajewo Ostrzeżenie: (0%)	Witam. Mam taką tabelę przechowującą kategorie i ich zalezności. Kod id \| parent \| neme \| level \| order "1",NULL,"root","0","0" "2","1","Rap / Hip Hop","1","0" "3","1","Graffiti","1","1" "4","1","Break Dance","1","2" "5","2","Polski","2","0" "6","2","Amerykański","2","1" "7","3","Graffiti","2","0" "8","3","Vlepki","2","1" "9","1","Street","1","3" "10","9","Skateboarding","2","0" "11","9","BMX","2","1" "12","9","streetball","2","2" Moje pytanie jest następujace. Czy jest mozliwość, aby jednym zapytaniem SELECT tak posortować te rekordy, aby najpier wyświetlało rodzica pierwszego rodzica (parent) wg. order, a potem jego dzieci wg. order, nastepnie kolejnego rodzica i jego dzieci? Np. Kod "1",NULL,"root","0","0" "2","1","Rap / Hip Hop","1","0" "5","2","Polski","2","0" "6","2","Amerykański","2","1" "3","1","Graffiti","1","1" "7","3","Graffiti","2","0" "8","3","Vlepki","2","1" "4","1","Break Dance","1","2" "9","1","Street","1","3" "10","9","Skateboarding","2","0" "11","9","BMX","2","1" "12","9","streetball","2","2" Może być bez root'a. Dziekuje za wszelką pomoc.