Re: Storing a linked list

2007-06-19 Thread Baron Schwartz
Celko also discusses them in SQL For Smarties. Baron Peter Brawley wrote: Matt >I'd like to store paths to specific destinations... See -- Tropashko's 'materialized modell' eg http://www.dbazine.com/oracle/or-articles/tropashko4 -- the airports example at http://www.artfulsoftware.com/mysq

Re: Storing a linked list

2007-06-19 Thread Peter Brawley
Matt >I'd like to store paths to specific destinations... See -- Tropashko's 'materialized modell' eg http://www.dbazine.com/oracle/or-articles/tropashko4 -- the airports example at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html PB - Matt Juszczak wrote: Hi all, I'

Re: Storing a linked list

2007-06-19 Thread Mogens Melander
How about: $id1 = 1; $id2 = 0; while ($id1) /** or ($id2 != 8) **/ { $sql = "select * from table where id1=$id1"; $row=query($sql); $id1=$row->id1; $id2=$row->id2; do_stuff(); $id1 = $id2 } On Tue, June 19, 2007 10:58, Matt Juszczak wrote: > Hi