|
By: df
Date: 2009-07-21
Time: 21:39
|
Serial display problem
Hi,
I am having problems displaying a serial block properly. I think I need a second pair of eyes to find the problem. Can anyone figure out what I'm doing wrong?
php is:
include_once('../class/tbs_class_php5.php') ;
//Connection to the database
require_once('CONNECTION PHP FILE');
$TBS = new clsTinyButStrong ;
$TBS->LoadTemplate('../<mytemplate>');
//$TBS->MergeBlock('bx',$cnx_id,"SELECT ProductCatalogID, ProductCatalog, HTMLTitle, Keywords, Meta_desc from DATABASE
// WHERE ProductCatalogID = $ProductCatalogID") ;
If ($ProductCatalogID <> 0)
{
$TBS->MergeBlock('cx',$cnx_id, "select ProductID, ProductName
from DATABASE where ProductCatalogID = $ProductCatalogID and Display = 1
order by ProductID");
}
else
{
$TBS->MergeBlock('cx',$cnx_id, "select ProductID, ProductName
from DATABASE where ProductCatalogID < 21 and Display = 1
order by ProductID");
}
$title='Dian Furniture Title';
$css='CSS';
mysql_close($cnx_id) ;
$TBS->Show() ;
|
The template portion that displays the serial block looks like this:
<td class="inside"><img src="../images-main/ID[cx_1.ProductID;block=td]/k[cx_1.ProductID;block=td]1.jpg" class="thumbnails"></td>
<td class="inside"><img src="../images-main/ID[cx_2.ProductID;block=td;.]/k[cx_2.ProductID;block=td;.]1.jpg" class="thumbnails"></td>
<td class="inside"><img src="../images-main/ID[cx_3.ProductID;block=td;.]/k[cx_3.ProductID;block=td;.]1.jpg" class="thumbnails">
[cx;block=tr;serial]</td>
</tr>
<tr>
<td colspan="3">[cx_0;block=td][bx;block=tr;serial]</td>
</tr>
|
The result looks like this:
http://www.dianfurniture.com/main/shop-v2.php?ProductCatalogID=1
It should look like this:
http://www.dianfurniture.com/main/shop-furniture.php?ProductCatalogID=1
Thanks. |