Clearance Sale ".$d_ko['項目en'].""; echo ' '; // for($i=0;$i<$ci;$i++){ // echo ''; // } for($i=1;$i<10;$i++){ if ($d_ko[M.$i]=="") break; echo ''; if ($i%5==4&&$i!=1) echo ""; } echo '
Click on the logo to jump to that brand`s product.
Back to Sale Homepage
'; echo "
"; $i=1; //echo $d_ko[M.$i]; while($d_ko[M.$i]!=""){ $sql ="select * from T_TQ where メーカー like '".$d_ko[M.$i]."' and 項目2 like '".$d_ko['項目2']."' order by 品番,カラー, ID ;"; $resc= odbc_exec($db_id,$sql); for ($ci=1;$ci<12;$ci++) {$caid[$ci]=0; $ccaid[$ci]=0;} $d = odbc_fetch_array($resc); while($d[ID]!=""){ for ($ci=1;$ci<12;$ci++){ $cii="P-".$ci; if ($d[$cii]!="") $caid[$ci]=1; } $d = odbc_fetch_array($resc); } odbc_free_result($resc); $cac=1; //for ($ci=1;$ci<12;$ci++) echo $caid[$ci]; for ($ci=1;$ci<12;$ci++) if($caid[$ci]==1) $ccaid[$cac++]=$ci; $cac--; //echo $cac;; //for ($ci=1;$ci<12;$ci++) echo $ccaid[$ci]; /////////////// カタログ数 $cac ID $ccaid $mkname[Butterfly]="Butterfly"; $mkname[Nittaku]="Nittaku"; $mkname[TSP]="TSP"; $mkname[Yasaka]="Yasaka"; $mkname[MIZUNO]="Mizuno"; $mkname[JUIC]="JUIC"; $mkname[DARKER]="DARKER"; $mkname[VI]="Victas"; $sql ="select * from T_meka where (mekaID like '".$d_ko[M.$i]."');"; $res= odbc_exec($db_id,$sql); $mk = odbc_fetch_array($res); $sql ="select * from T_koumoku where (項目 like '".$d_ko[項目]."');"; $tres= odbc_exec($db_id,$sql); $fo = odbc_fetch_array($tres); $sql ="select * from T_TQ where メーカー like '".$d_ko[M.$i]."' and 項目2 like '".$d_ko['項目2']."' order by 品番,カラー, ID ;"; $res= odbc_exec($db_id,$sql); //odbc_result_all($res); $old_hid=1; $d = odbc_fetch_array($res); while($d[ID]!=""){ if($old_hid==1){ $coln=3+$cac; echo "
"; // echo ' // 品 番 // 品  名 // 販売価格'; for ($ci=0;$ci<$cac;$ci++){ $sql ="select * from T_katarogu where P like 'P-".$ccaid[$ci+1]."' ;"; $rescc= odbc_exec($db_id,$sql); $dc = odbc_fetch_array($rescc); $cfname="../../photo/catalog/".$dc['カタログ名']."/thumb.gif"; $curl="../Catalog/".$dc['カタログ名']."/thumb01.html"; $dc2[$ci+1]=$dc['カタログ名']; echo '

'; } echo '
"; } } $i++; } //$d_mk[ID]!="" }//start echo"
"; ?>