Are linked list with MySQL possible (advanced user only) ?

xhtml · #1 (**permalink**) 01-21-2006, 10:54 AM

For experts only :

Does any expert know how to make a MySQL request with only one (select and subselect) without using any loop with PHP ?
Sample data :

Code:

index    field       next
======|======|=====
1           car        3
2           boat       4
3           house    2
4           rocket    0

mikesmith76 · #2 (**permalink**) 01-21-2006, 01:33 PM

may be able to answer with more information, for a start what are you trying to achieve?

sacx13 · #3 (**permalink**) 04-12-2006, 01:15 PM

Quote:

Originally Posted by xhtml

For experts only :

Does any expert know how to make a MySQL request with only one (select and subselect) without using any loop with PHP ?
Sample data :

Code:

index    field       next
======|======|=====
1           car        3
2           boat       4
3           house    2
4           rocket    0

Something like that :

Code:

select * from table as t1 left join table as t2 on t2.field=t1.index;

???????????
This is what you want ?