Please..... Help....

[eluser]davidbehler[/eluser]
try something like this:

Code:

select *, CASE parentid when "0" then id else parentid
END as order_by
from category
order by order_by ASC, parentid ASC

that's untested and might need some tweaking, but in my opinion something like this should work for you.