|
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> </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? |