$hor_nb=4; //horizental number-image
$ver_line_nb=1; //vertical line number
$hor_nb1=$hor_nb-1;
$limit=$hor_nb*$ver_line_nb;
$relate_itm_qry=mysql_query("select * from $abj_prdt_relate_items where odr_prdt_id='$itm_id' order by odr_prdt_pur_num desc limit 0,$limit");
if(!mysql_num_rows($relate_itm_qry)){
echo ("We have nothing in this series.");
}else{?>
$aNo=0;
while($relate_itm_rslt=mysql_fetch_array($relate_itm_qry)){
$item_prdtid=$relate_itm_rslt[odr_prdt_rel_id1];
$itmdtl_qry=mysql_query("select * from $tinatouch_prdt_product where prdt_id='$item_prdtid'");
$boardqry_rslt=mysql_fetch_array($itmdtl_qry);
$prdt_name=$boardqry_rslt[prdt_name];
if(strlen($prdt_name) > 16){
$prdt_name=substr($prdt_name,0,15);
$prdt_name=$prdt_name.'..';
}else{}
$prdt_dis_factor="";
$prdt_price=$boardqry_rslt[prdt_price1];
$prdt_dis_price=$boardqry_rslt[prdt_dis_price2];
if($prdt_dis_price>0 && $prdt_price > $prdt_dis_price){
$prdt_dis_factor="Y";
}
$prdt_size=$boardqry_rslt[prdt_size];
$prdt_subchk_qry=mysql_query("select * from $tinatouch_prdt_subitem where prdt_id='$boardqry_rslt[prdt_id]' order by id asc");
$prdt_subchk_numrows=mysql_num_rows($prdt_subchk_qry);
$prdt_sub_size_no=0;
if(!$prdt_subchk_numrows){}else{
for($i=0;$i<$prdt_subchk_numrows;$i++){
$sprdt_price=mysql_result($prdt_subchk_qry,$i,7);
$sprdt_dis_price=mysql_result($prdt_subchk_qry,$i,9);
$sprdt_size=mysql_result($prdt_subchk_qry,$i,5);
if($sprdt_price){
$prdt_sub_size_no++;
}
$prdt_size=$prdt_size.', '.$sprdt_size;
if($sprdt_dis_price >0 && $sprdt_dis_price < $sprdt_price){
$prdt_dis_factor="Y";
}}}
$prdt_number=$boardqry_rslt[prdt_id];
$prdt_price_unit=$boardqry_rslt[prdt_sales_unit1];
$img_name=$boardqry_rslt[img1_filename];
$item_number=$boardqry_rslt[id];
$item_prdtid=$boardqry_rslt[prdt_id];
$Vno=$aNo%$hor_nb;
if($Vno==0){?>