{php} $link = mysql_connect("localhost","toriand1_toriand","Diam0ndT")or die("Couldn't connect to MySQL");
mysql_select_db("toriand1_tdiamond") or die(mysql_error());
include("xpertfunc.php");
$pg = new paging;
$sql="SELECT C.*,M.productid from xcart_images_T C ,xcart_products M where C.id = M.productid";
$sqlcount=str_replace("SELECT C.*,M.productid from","select count(*) from",$sql);
$pg->setpages($sqlcount);
$cmdcount=mysql_query($sqlcount);
$rscount=mysql_fetch_array($cmdcount);
$foundcount=$rscount[0];
$sql .=$pg->getlimit();
//echo $sql;
$cmd=mysql_query($sql);
{/php}
{php}
$count=0;
while($rs=mysql_fetch_array($cmd)){
$imagepath=str_replace("./","http://seating4offices.co.uk/",$rs["image_path"]);
$iftrclosed=0;
$count=$count+1;
if (($count%3)==1) echo "";{/php}
{php}
if (($count%3)==0) {
$iftrclosed=1;
echo "";
}
}
{/php}
|
| {php} $pg->showPaging("","&ps=".$_GET["ps"]."&sort=".$_GET["sort"]."&sortorder=".$_GET["sortorder"]."&pageid=".$_GET["pageid"]."&search_text=".$_GET["search_text"]); {/php} |
