#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    1
    Rep Power
    0
    How do I select records in the hierarchical structure, parent and child format.
    Example

    ID PARENTID
    A01 A00
    A02 A01
    A03 A02
    A05 A02
    A06 A05
    A07 A06
    A08 A01

    The output should looks like this.

    A01
    A02
    A03
    A05
    A06
    A07
    A08

  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    Is this data all in the same column? Can't you just use

    SELECT id FROM your_table

    ?? Maybe I'm missing something?

    ---John Holmes...

Similar Threads

  1. prevent duplicate entries in select menu
    By SeenGee in forum PHP Development
    Replies: 2
    Last Post: February 6th, 2004, 07:08 AM
  2. select verification onsubmit
    By DrStein in forum HTML Programming
    Replies: 3
    Last Post: January 20th, 2004, 03:16 AM
  3. select distinct problem
    By mrengc in forum MS SQL Development
    Replies: 1
    Last Post: December 23rd, 2003, 07:50 AM
  4. Help with javascript, passing multiple select array to js then php
    By zen^Wallhack! in forum JavaScript Development
    Replies: 1
    Last Post: December 3rd, 2003, 01:56 PM
  5. Help with function to copy contents of select item
    By MilesDependent in forum HTML Programming
    Replies: 2
    Last Post: November 23rd, 2003, 06:16 PM

IMN logo majestic logo threadwatch logo seochat tools logo