Multi-level Template - PHP SOLUTION

Here is the html template  
--------------------------------------------------------------------------  
<table cellspacing="0" cellpadding="0" width="100%" border="0">  
  <tr>  
    <td valign="top">  
      <table class="Header" cellspacing="0" cellpadding="0" border="0">  
        <tr>  
          <td class="HeaderLeft"><img src="../../Styles/GSM/Images/Spacer.gif" border="0"></td>   
          <th>Forum</th>  
   
          <td class="HeaderRight"><img src="../../Styles/GSM/Images/Spacer.gif" border="0"></td>   
        </tr>  
   
      </table>  
   
      </td>   
  </tr>  
   
  <tr>  
    <td valign="top">  
      <!-- BEGIN forum_group -->  
      <table class="Header" cellspacing="0" cellpadding="0" border="0">  
        <tr>  
          <td>{forum_group_name}</td>   
        </tr>  
   
      </table>  
   
      <table class="Grid" cellspacing="0" cellpadding="0" width="100%">  
        <tr class="Caption">  
          <th width="60%">{res:GSM_forum}</th>  
   
          <th width="10%">{res:GSM_forum_subject}</th>  
   
          <th width="10%">{res:GSM_forum_messages}</th>  
   
          <th width="20%">{res:GSM_forum_lastmsg}</th>  
   
        </tr>  
   
  
        <!-- BEGIN forum_item -->  
        <tr class="Row">  
          <td>{forum_name}</td>   
          <td>{forum_subjects}</td>   
          <td>{forum_messages}</td>   
          <td>{forum_last_message}<br>  
            by {forum_last_user}</td>   
        </tr>  
 <!-- END forum_item -->  
      </table>  
   
      <hr><!-- END forum_group --></td>   
  </tr>  
   
  <tr>  
    <td valign="top"> </td>   
  </tr>  
</table>  

  
Here is the BeforeShow event code  
----------------------------------------------------------------  
//Custom Code @2-2A29BDB7  
// -------------------------  
global $Tpl;  
  	//	list forum groups  
    $db		=	new	clsDBgsm();  
	$SQL	=	"SELECT * FROM app_gsmkb_forum_group ORDER BY group_index";  
	$db->query( $SQL);  
  
	//	parse result  
	while( $db->next_record())	{  
		//	retrieve datas  
		$group_id		=	$db->f( "group_id");  
		$group_name		=	$db->f( "group_name_default");  
  
		//	list group forum's  
		$l_db	=	new	clsDBgsm();  
		$l_SQL	=	"SELECT * FROM app_gsmkb_forum_list WHERE group_id=$group_id ORDER BY list_index";  
		$l_db->query( $l_SQL);  
  
		//	---> go up on the templte tree  
		$bp		=	$Tpl->block_path;  
		$Tpl->block_path	=	$Tpl->block_path . "/forum_group";  
  
		//	parse result  
		//	!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  
		//	!!!	Reset block value ( clear accumulation)  
		$Tpl->SetBlockVar( "forum_item", "");	  
		while( $l_db->next_record())	{  
  
	  		//	retrieve datas  
	  		$forum_id			=	$l_db->f( "forum_id");  
	  		$forum_name			=	$l_db->f( "list_name_default");  
	  		$forum_subjects		=	$l_db->f( "count_subject");  
	  		$forum_messages		=	$l_db->f( "count_msg");  
	  		$forum_last_time	=	$l_db->f( "last_time");  
	  		$forum_last_user	=	$l_db->f( "last_user");  
	    
	  		//	build template  
	  		$Tpl->SetVar("forum_name", $forum_name);  
	  		$Tpl->SetVar("forum_subjects", $forum_subjects);  
	  		$Tpl->SetVar("forum_messages", $forum_messages);  
	  		$Tpl->SetVar("forum_last_time", $forum_last_time);  
	  		$Tpl->SetVar("forum_last_user",$forum_last_user);  
	  		$Tpl->Parse("forum_item", true);  
	  	}  
  
		//	retrieve template generated block  
		//	!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  
		//	!!!	Read block value ( current accumulation)  
		$forum_list_block	=	$Tpl->GetVar("forum_item");		  
//		$forum_list_block	=	"<tr class='Row'><td>{forum_name}</td><td>{forum_subjects}</td><td>{forum_messages}</td><td>{forum_last_message}<br>by {forum_last_user}</td></tr>";  
  
		//	<--- go down on the templte tree  
		$Tpl->block_path	=	$bp;  
  
		//	build template  
		//	!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  
		//	!!!	Set block value ( at the right tree level)  
		$Tpl->SetBlockVar( "forum_item", $forum_list_block);  
		$Tpl->SetVar("forum_group_name", $group_name);  
		$Tpl->Parse("forum_group", true);  
	}  
  
  
// -------------------------  
//End Custom Code  

     Here are     s     p     a     c     e      s

	Here are		t	a	b	s