Hi Daniel, I can think of a table with columns like this: prvlink item nextlink
where prvlink and nextlink points to the previous and next nodes and item is the current node. prvlink = 0 for first node nextlink = 0 for last node Hope this helps Joseph ----- Original Message ----- From: "Daniel Jarrett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 29, 2002 9:19 AM Subject: [newbie post] linked lists.. > is there any way of doing a linked list in mysql.. > ? > > the only alternative i've got is to have a table with a fixed number of > columns liike this > item1 > item2 > item3 > item4...etc > > is this the only way to do what i'm trying to do. > does anyone get what i'm on about? > > cheers > dan > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php