[PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Age Bosma
I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db. Starting with the first main branch listing it's first child branch followed by it's children, after that the second child branch, ect. When the first main

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Hutchins, Richard
] Subject: [PHP-DB] MySQL category tree db sorting I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db. Starting with the first main branch listing it's first child branch followed by it's children, after

Re: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread John W. Holmes
From: Age Bosma [EMAIL PROTECTED] I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db. Search the archives or Google for nested sets. That's going to be the most efficient database scheme to use. Any

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Galbreath, Mark A
] Sent: Friday, March 19, 2004 11:42 AM To: [EMAIL PROTECTED]; Age Bosma Subject: Re: [PHP-DB] MySQL category tree db sorting From: Age Bosma [EMAIL PROTECTED] I'm trying to work out what the most efficient way will be to get the complete tree structure from top to bottom of a category tree db