set_total($sqlcount); $result = $paging->get_results($sql); $result02 = $paging->get_results($sql); $result03 = $paging->get_results($sqlcat); $resultProductLine = mysql_query($sql) or die($sql); $rsProductLine = mysql_fetch_array($resultProductLine); /**********************************PAGE***************************/ $count_query = $sqlcount; $result222 = mysql_query($count_query) or die($count_query); //echo $count_query."

"; $myrowaaa = mysql_fetch_array($result222); $total = $myrowaaa[0]; if ($total == '') { $total == "null";} $scale=9; $page = $_REQUEST['page'] ; if ($page == ''){ $page=1; } if($page != 'all') { $cpage = intval($page); $totalpage = intval($total/$scale); if ($totalpage*$scale != $total) $totalpage = $totalpage + 1; if ($cpage ==1) { $cline = 0 ; } else { $cline = ($cpage*$scale) - $scale ; } $limit=$cline+$scale; if ($limit >= $total) $limit=$total; $scale1 = $limit - $cline; $limit_portion = "LIMIT $cline,$scale1 "; } else { $totalpage = ceil($total/$scale); $limit_portion = ""; } $limit_portion = " ".$limit_portion; /***************************************************************/ ?> Special and Promotions
  Home > Specials and Promotions
Specials and Promotions
 
 
"; } ?> "; } $count++; } ?>
- ">
...
* Discount: -$".$rspromo["discount"].""; }?>
0) { ?> $
- ">Learn More
 
"; } else { if(file_exists("a-upload-images/sml/".$rs['sml'])) { $itemImg = ""; } else { $itemImg = ""; } } return $itemImg; //return $sql; } ?>