View Single Post

   
  #8 (permalink)  
Old 02-28-2008, 11:28 AM
=?iso-8859-1?B?Sm/jbyBNb3JhaXM=?=
 
Posts: n/a
Default Re: Child and parent rows

SELECT m1.id, m1.idParent, m1.name, m1.position
FROM menuitens m1
LEFT JOIN menuitens m2 ON m1.id=m2.id AND m1.idParent<m2.idParent
WHERE m2.idParent IS NULL
ORDER BY m1.position, m1.idParent

This one almost does what I need, result provided:

id | idParent | name | position
5 0 a 1
12 5 a1 1
13 12 a11 1
9 13 a111 1
14 0 b 2
10 5 a2 2
11 5 a3 3

(id 14 should be at the bottom)

When it should be:

id | idParent | name | position
5 0 a 1
12 5 a1 1
13 12 a11 1
9 13 a111 1
10 5 a2 2
11 5 a3 3
14 0 b 2

Hope someone can help me on this, cause I dont want to use recursive
solutions since this script will be used often and thats not good for
the server.

Reply With Quote