$module = "catalog";
$sagmenu = "0";
$title = "Treading Area - Online Catalog";
include "../header.php";
$kategori = htmlspecialchars($_REQUEST['CatId']);
$SektorSql = mysql_query("select c.CatId, c.CatName, SubId, SubCatName from categories c, subcategories s where c.CatId = s.CatId and s.SubId = '".$kategori."' ");
$Sektor = mysql_fetch_array($SektorSql);
?>
Home > Online catalog
> -
$max=10;
$page=$_GET['page'];
if (!isset($page)) $page=1;
if ($page=="") $page=1;
$limit1=($page - 1) * $max;
$ToplamSql = mysql_query(
"select count(u.id) as sayfasayisi
from urun u, subcategories s, members m, country c
where s.SubId = '".$kategori."'
and u.sektor = s.SubId and m.id = u.fid
and c.CountryId = m.country
");
$sayfa_sayisi = mysql_result($ToplamSql, "sayfasayisi");
$UrunSql = mysql_query(
"select u.*, m.id as MemberId, m.company, c.CountryName
from urun u, subcategories s, members m, country c
where s.SubId = '".$kategori."'
and u.sektor = s.SubId and m.id = u.fid
and c.CountryId = m.country
limit $limit1, $max
");
$UrunSay = mysql_num_rows($UrunSql);
for ($i=0; $i<$UrunSay; $i++) {
$Urun = mysql_fetch_array($UrunSql);
if (gettype($i/2)=="integer") { $arkarenk = "f1f1f1"; } else { $arkarenk = "ffffff"; }
?>
$zxvf = "../";
if (is_file($zxvf.$Urun['resim1'])) {
resim($mypath.$Urun['resim1'], 120, 100) ;
} else {
echo "\n";
}
?>
|
|
Sell May 21, 2005
|
|
}
?>
$sayfax = ceil($sayfa_sayisi/$max);
if ($sayfax > 1) {
//echo "Pages: ";
if ($page > 1) {
$onceki_sayfa = $page - 1;
echo "<< Prior ";
}
for ($ci =1; $ci < $sayfax+1; $ci++) {
if ($page == $ci) { echo " " . $ci . " \n"; }
else { echo " $ci \n"; }
}
if ($page != $sayfax) {
$sonraki_sayfa = $page + 1;
echo "Next >> ";
}
}
?>
$limit2 = $limit1 + $max;
if ($limit2 > $sayfa_sayisi) { $limit2 = $sayfa_sayisi; }
?>
Showing Results - , from
|
include "../footer.php";
?>