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,
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
SOLVED, 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
3 matches
Mail list logo