That's an adjacency list, not nested sets. See my second example (though I omitted the normalized keys for brevity).
cheers, barneyb On 2/1/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > That's not the way I've got my db set up. Mine looks like this: > > id|name|parent > 1|Books|0 > 2|Sci/Fi|1 > 3|Starship Troopers|2 > 4|Friday|2 > > So if I deleted Sci/Fi, records 3 and 4 would be orphaned. > > I'm using mySQL by the way (if it matters). > > > <!----------------//------ > andy matthews -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230978 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54