Gallery

{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}