recursive functions

[thinkninja]

[e-mail]

I make recursive calls to displayComments function incrementing the level at which it returns comments. This gives threaded comments but how do I make it multipage? Like a regular forum with a LIMIT 0, 30/LIMIT 30, 30 for page1/page2 and so on? Thanks for any help 🙂

[daynah]

LIMIT 0, 30/LIMIT 30, 30

Well, the pattern is $offset 30, 30. So your query would be something like SELECT FROM YOURTABLE LIMIT($offset * 30, 30) 🙂

The offset will be your page number (say page 3, it'll be 30 * 3 -- so it starts from entry 90 and prints out entries 90 - 120).

[thinkninja]

But I can't use LIMIT because each recursive call to the function has it write out child replies of that parent. I'm not selecting all the replies at the same time. I think I'll probably declare another global (or two!) and increment it 😉