Results 1 to 2 of 2

Thread: sql linked list

  1. #1

    sql linked list

    Hi y'all.

    I'm having trouble getting my head around this.

    i have a table:

    tbl_test
    fields: id, text, parentid.

    parentid is a reference to id in the same table.

    entries could be:

    1 | sometext | -1;
    2 | sometext | -1;
    3 | sometext | 1;
    4 | sometext | -1;
    5 | sometext | 3;
    6 | sometext | -1;

    what i want from a query:

    give me all entries that have a link to record 1 trough the parentid.

    so from the list above i would want:

    1, 3, 5

    I have no idea how to do this can anyone point me in the wright direction?
    thx...

  2. #2
    1,627
    posts
    hugeExplosions = true;
    You might want to consider using nested sets as they are easier to maintain a heirarchy with (I'm assuming this is for a menu system)

    The problem with your query is that you can't really do recursion in a SQL query without knowing the recursive depth you need. You can use a table function but it's probably easier going the nested set route.
    MS Paint FTW!


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012