, almost. I read the article suggested by K.Bear and found the
recommended solution to be a bit more complicated than I wanted to
implement. I then found another way to do this using the existing
"Adjacency List Model" through a recursive function. So basically, you
query the database for the post
Sounds like that darn Hierarchial Data again. Give this a read and see if it
helps you out at all. In particular, you may find the area 'Finding the
Depth of the Nodes' helpful.
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Hope it helps,
-K.Bear
--
PHP General Mailing Lis
On 6/29/06, Adam Zey <[EMAIL PROTECTED]> wrote:
Just throwing an idea out there, but you can do the sorting entirely in
the SQL query. The trick is to figure out the best way.
The first idea that came to mind (and it sucks, but it works), is a text
field with padded numbers separated by dots, a
3 matches
Mail list logo