Search Site

    $count){ $end=$count; }else{ $end= $start_i+$perPage-1; } $s=$start_i-1; $e=$end; $query="select * from shopcloth where SHID=".$shopid." and CID=$categoryid and AID=$typeid LIMIT $s , $e"; $r = mysql_db_query ($database, $query, $link) or die(mysql_error()); } else{ if(empty($category)){$query="select * from category order by CID";} else { if($lan==0) $query="select * from category where cName='$category'"; else $query="select * from category where cEnglish='$category'"; } $r = mysql_db_query ($database, $query, $link) or die(mysql_error()); if(mysql_num_rows($r)<=0){ $query="select * from category "; $r = mysql_db_query ($database, $query, $link) or die(mysql_error());} $rr=mysql_fetch_array($r); $categoryid=$rr['CID']; $query="select * from shop where shopName='$shop'"; $r = mysql_db_query ($database, $query, $link) or die(mysql_error()); $rr=mysql_fetch_array($r); $shopid=$rr['SHID']; $query="select * from shopcloth where SHID=".$shopid." and CID=".$categoryid." "; $r = mysql_db_query ($database, $query, $link) or die(mysql_error()); $count=mysql_num_rows($r); if(!isset($_GET['start'])) $start_i = 1; else $start_i = $_GET['start']; $perPage=8; if(($start_i+$perPage) > $count){ $end=$count; }else{ $end= $start_i+$perPage-1; } $s=$start_i-1; $e=$end; if(empty($categoryid)){$categoryid=1;} if(empty($shopid)){$shopid=35;} $query="select * from shopcloth where SHID=".$shopid." and CID=".$categoryid." order by clothID LIMIT $s , $e"; $r = mysql_db_query ($database, $query, $link) or die(mysql_error()); } if($count>=0){ for($x=$start_i-1;$x<$end;$x++){ $rr=mysql_fetch_array($r); ?>



spacer
of