$result_per_page=20;
include ("header.php");
?>
if(!$catid){$sqld="select id,$db_ext_lang"."name,parent_cat from categories where
parent_cat='0'";}
else{$sqld="select id,$db_ext_lang"."name,parent_cat from categories where parent_cat='$catid'";
$dfgdfg=mysql_query("select id,$db_ext_lang"."name,parent_cat from categories where
id='$catid'");
list($idhs,$namegsd,$parent_exist)=@mysql_fetch_row($dfgdfg);
$i=1;
$jkfdss="categoryname$i";
$$jkfdss="$namegsd >";
while($parent_exist){
$dfgdfg=mysql_query("select id,$db_ext_lang"."name,parent_cat from categories where
id='$parent_exist'");
list($idhs,$namegsd,$parent_exist)=@mysql_fetch_row($dfgdfg);
$i++;
$jkfdss="categoryname$i";
$$jkfdss="$namegsd >";
}
echo"
$lang_prod_dir >";
for($y=$i;$y>=0;$y--){
$jkfdss="categoryname$y";
$stww=$$jkfdss;
echo"$stww";
}
echo"
";
}
$fdgd=mysql_query($sqld);
echo"
";
$counter_row=0;
while(list($idf,$namef,$parent_catf)=@mysql_fetch_row($fdgd)){
$dfgdffg=mysql_query("select * from products where parent_cat='$idf'");
$drtgdf=mysql_num_rows($dfgdffg);
echo"| $namef($drtgdf) | ";
$counter_row++;
if($counter_row==3){echo"
";$counter_row=0;}
}
echo"
";
if(!$prodid){
if(!$catid){echo"$langchoos
";}
else{
$sdgdgggfg=mysql_query("select $db_ext_lang"."name,$db_ext_lang"."description from categories
where id='$catid'");
list($namef,$catdesc)=@mysql_fetch_row($sdgdgggfg);
echo"$namef
";
if($picturedd){echo"$catdesc";}
echo"
";
$osdfjgn=mysql_query("select * from products where parent_cat='$catid'");
$total_records = mysql_num_rows($osdfjgn); echo"
$total_records
";
$pages = ceil($total_records / $result_per_page);
if ($total_records!="0"){
if (!isset($screen)){ $screen = 0;}
$start = $screen * $result_per_page;$prev= $screen - 1;$next=$screen +1;
if($prev!=-1){echo "<< ";}
else{echo"<< ";}
for($i=0;$i<$pages;$i++){ $number=$i+1;
if($screen!=$i){echo"| $number";}
else{echo"| $number ";}
}
if($next<=($pages-1)){ echo "| >>\n";}
else{echo"| >>";}
}
$osdfjgn=mysql_query("select id,$db_ext_lang"."name,code,price from products where
parent_cat='$catid' order by date_added limit $start, $result_per_page");
echo"";$dfghfghcolor=1;
while(list($id,$name,$code,$price)=@mysql_fetch_row($osdfjgn)){
$dfggh=mysql_query("select image_name from products_images where product_id='$id' and main='1'");
list($image_name)=@mysql_fetch_row($dfggh);
echo" $name | ";
if($dfghfghcolor==3){$dfghfghcolor=0;echo"
";}
$dfghfghcolor++;
}echo"
";
}
}
if($prodid){
$doifg=mysql_query("select
$db_ext_lang"."name,$db_ext_lang"."description,parent_cat,views,code,price from products where
id='$prodid'");
list($name,$description,$parent_cat,$views,$code,$price)=@mysql_fetch_row($doifg);
$fkmhkf=mysql_query("select $db_ext_lang"."name from categories where id='$parent_cat'");
list($fghname)=@mysql_fetch_row($fkmhkf);
echo"
Order Now
| $name |
| Price for this item :$price | Code for this item :$code |
";
$gg=mysql_query("select id,image_name,main from products_images where product_id='$prodid'");
echo""; $i=1;
while(list($id,$image_name,$mains)=@mysql_fetch_row($gg)){
echo" | ";
if($i==3){$i=0;echo" ";} $i++;
} echo" ";
$description=stripslashes($description);
if(!$description){echo"$description=$lang_noDesc";}
echo" |
| $description |
$langgoback"; $views++;
mysql_query("update products set views='$views' where id='$prodid'");
}
include ("footer.php");?>