"; exit; } } if(!empty($stuffid)){ //判斷變數是否為NULL if(!is_numeric($stuffid)){ echo ""; exit; } } if(!empty($typeid)){ //判斷變數是否為NULL if(!is_numeric($typeid)){ echo ""; exit; } } //產品 $sql="select * from ".$table_product." where xpublish='yes'"; if($sexid!=''){ $sql.=" and xrelate LIKE '%".$sexid."%'"; } if($stuffid!=''){ $sql.=" and xrelate2 LIKE '%".$stuffid."%'"; } if($typeid!=''){ $sql.=" and xtype LIKE '".$typeid."'"; } $sql.=" order by xorder desc"; //echo $sql; $result->ExecSQL($sql); $xcount_p = $result->fetchNum(); if($xcount_p > 0){ for($i=0 ; $i<$xcount_p ; $i++){ $record = $result->fetchRow(); $pid_p[$i] = stripslashes($record['pid']); $xtitle_p[$i] = stripslashes($record['xtitle']); $xpic_p[$i] = stripslashes($record['xpic']); $xcolor_p[$i] = stripslashes($record['xcolor']); $xprice_p[$i] = stripslashes($record['xprice']); $xprice2_p[$i] = stripslashes($record['xprice2']); } } //鞋款 $sql = "select * from ".$table_product_sex." where xpublish='yes' order by xorder desc "; $result->ExecSQL($sql); $xcount_sex = $result->fetchNum(); if($xcount_sex > 0){ for($i=0 ; $i<$xcount_sex ; $i++){ $record = $result->fetchRow(); $pid_sex[$i] = stripslashes($record['pid']); $xtitle_sex[$i] = stripslashes($record['xtitle']); } } //材質 $sql="select * from ".$table_product_stuff." where xpublish='yes' order by xorder desc "; $result->ExecSQL($sql); $xcount_stuff = $result->fetchNum(); if($xcount_stuff > 0){ for($i=0 ; $i<$xcount_stuff ; $i++){ $record = $result->fetchRow(); $pid_stuff[$i] = stripslashes($record['pid']); $xtitle_stuff[$i] = stripslashes($record['xtitle']); $xpic_stuff[$i] = stripslashes($record['xpic']); } } //版型 $sql="select * from ".$table_product_type." where xpublish='yes' order by xorder desc "; $result->ExecSQL($sql); $xcount_type = $result->fetchNum(); if($xcount_type > 0){ for($i=0 ; $i<$xcount_type ; $i++){ $record = $result->fetchRow(); $pid_type[$i] = stripslashes($record['pid']); $xtitle_type[$i] = stripslashes($record['xtitle']); } } ?> FYE - 為了地球 | 從鞋子開始就是從文明開始 |
0){ ?>
--- 目前沒有相關產品 ---