You're basically paging through results. You have a SQL statement to get the data - just limit the statement to only draw information applicable to the page you're on. Like this:
select * from table limit 0,10; That will select the first 10 records. Then you can use variables. if (empty($P)) $P = 0; $C = 10; select * from table limit $P, $C Make a link at the bottom $NextPage = $P + $C; if ($P > $C) $PreviousPage = $P - $C; else $PreviousPage = 0; print "<a href='next.php?P=$NextPage'>Next Page</a>"; You get the idea... -----Original Message----- From: Alexander Ross [mailto:[EMAIL PROTECTED]] Sent: Monday, July 08, 2002 6:22 PM To: [EMAIL PROTECTED] Subject: [PHP] tree structures I am creating a message board (pretty standard) using php and mysql. In order to manage all the posts and replies I am using a treenode structure (so that I can recursively add, delete, display, etc...) Everything works so far (www.bleen.net/forum). I want to be able to display 10 posts (including relies in that count) at a time; then have a next link and display the next 10 (you've all seen it before). How do I modify a recursive function to stop and start? My display finction is listed below. Thanks Alexander Ross function display($row, $start = 0) { //display the tree if($this->m_postid<>0) { // if this is the empty root node skip displaying print "<tr><td bgcolor="; if ($row%2 == 0) print "'#cccccc'>"; else print "'#ffffff'>"; // indent replies to the depth of nesting print "<img src='images/spacer.gif' height=22 width=".(22*$this->m_depth)." alt='' valign = bottom>"; print " <a name = $this->m_postid ><a href = 'view_post.php?postid=$this->m_postid'>"; if ($this->m_depth == 1) print "<b> '$this->m_title' - $this->m_poster <i>(".reformat_date($this->m_posted).")</i></b></a>"; else print "'$this->m_title' - $this->m_poster <i>(".reformat_date($this->m_posted).")</i></a>"; print "</td></tr>"; } // increment row counter to alternate colors $row++; $num_children = count($this->m_childlist); for($i = 0; ($i<$num_children); $i++) { // call display on each of this node's children $row = $this->m_childlist[$i]->display($row); } return ($row); } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php **************************************************************************** This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete the message. Thank you very much. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php