Categories > TinyButStrong general >

Sub-Block Problem...

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Rromulo
Date: 2008-04-25
Time: 16:11

Sub-Block Problem...

My Html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
<p align="center" class="title-page">Fóruns Cadastrados</p>

<table border="1" align="center" cellpadding="2" cellspacing="0">

  <tr bgcolor="#CACACA">
    <td>&nbsp;</td>
    <td><strong>Título do Fórum</strong></td>
    <td><strong>Data da criação</strong></td>
    <td><strong>Dono do Fórum</strong></td>
  </tr>
   
  <tr bgcolor="#F0F0F0">
    <td>[blk1.#]</td>
    <td><a href="forum.php?forum=[blk1.forum_id]">[blk1.forum_titulo;block=tr;p1=[blk1.forum_id]]</a></td>
    <td><div align="right">[blk1.forum_data_cadastro;frm='dd-mm-yyyy']</div></td>
    <td><div align="right">[blk2.usuario_forum_id]</div></td>
  </tr>
 
  <tr bgcolor="#E6E6E6">
    <td colspan="4" bgcolor="#FFCFB9">[blk1;block=tr;nodata]Não Existem Fóruns Cadastrados. </td>
  </tr>
 
</table>

<p align="center">Existem [blk1.#] fóruns cadastrados.</p>

<p align="center"><b>[var.sql1]</b></p>

</body>
</html>

My PHP
<?php

include_once('classes/tbs/tbs_class.php') ;

$cnx_id = mysql_connect('localhost','zzzzzz','zzzzz') ;
             mysql_select_db('pedro_forum',$cnx_id) ;
            
    $TBS = new clsTinyButStrong ;
    $TBS->LoadTemplate('teste.htm') ;

    $sql1 = '';
    $sql1 = $sql1.'SELECT forum_id, forum_titulo, forum_descricao, forum_data_cadastro ' ;
    $sql1 = $sql1.'FROM forum' ;

    $TBS->MergeBlock('blk1',$cnx_id,$sql1) ;
    $TBS->MergeBlock('blk2',$cnx_id,'SELECT * FROM usuario_forum WHERE (usuario_id=\'%p1%\')');
   
    mysql_close($cnx_id) ;

    $TBS->Show() ;
            
?>



Mine blk2 returns emptiness and I do not obtain to understand where this the problem. It will be that somebody verifies some error?
By: Skrol29
Date: 2008-04-25
Time: 18:44

Re: Sub-Block Problem...

Hello,

Parameter p1 should be on "blk2", not on "blk1".
[blk2.usuario_forum_id;block=div;p1=[blk1.forum_id]]