ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Query ordering problem

June 27, 2011 10:20am

Subscribe [1]
  • #1 / Jun 27, 2011 10:20am

    pushloop

    422 posts

    Hey

    I need help with sorting a seemingly trivial query.

    I’ve got a table with titles that looks like this:

    ID——PARENT_ID——TITLE
    01——03—————-Steve
    02——05—————-Lene
    03——00—————-Marv
    04——03—————-John
    05——00—————-Lisa

    I would like to output this like below (preferably as two separate ul-lists), i.e. sorted by and listed under their parent.

    Marv
    -Steve
    -John

    Lisa
    -Lene

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases