selectSQLAll("select * from $Table[Product] where $find = '$search' $order"); $rnum = $result[rnum]; if($find=="pbest") $PresentTitle = "베스트 상품"; if($find=="pnew") $PresentTitle = "이벤트 상품"; if($find=="precom") $PresentTitle = "추천상품"; if($find=="ppopu") $PresentTitle = "인기상품"; }else{ if(!$orname && !$orsun) $order = " order by updatetime desc"; else $order = " order by $orname $orsun"; $r = $dalib->selectSQLField("select bigcatename from $Table[Bigcategory] where bigcate ='$bigcate'"); $r2 = $dalib->selectSQLField("select smcatename from $Table[Smcategory] where smcate ='$smcate'"); $r3 = $dalib->selectSQLField("select thirdcatename from $Table[Thirdcategory] where thirdcate='$thirdcate'"); $PresentTitle = $r[bigcatename]; $PresendSmcate = $r2[smcatename]; $PresendThirdcate = $r3[thirdcatename]; $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and display = '1' $order"); if($smcate=="" && $thirdcate=="") $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and display = '1' $order"); elseif($smcate!="" && $thirdcate=="") $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and smcate = '$smcate' and display = '1' $order"); else $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and smcate = '$smcate' and thirdcate = '$thirdcate' and display = '1' $order"); $rnum = $result[rnum]; } $pagingList = $paging2->pagingList("mode=$mode&bigcate=$bigcate&smcate=$smcate&thirdcate=$thirdcate&bigcatename=$bigcatename&smcatename=$smcatename&thirdcatename=$thirdcatename&orname=$orname&orsun=$orsun&search=$search&find=$find",$rnum,40,10); $startRecord = $paging2->startRecord; $endRecord = $paging2->endRecord; $page = $paging2->page; $result2 = $dalib->selectSQLAll("select * from $Table[Smcategory] where bigcate = '$bigcate' order by cateorder asc"); $result3 = $dalib->selectSQLAll("select * from $Table[Thirdcategory] where bigcate = '$bigcate' and smcate = '$smcate' order by updatetime desc"); //echo ("select * from $Table[Thirdcategory] where bigcate = '$bigcate' and smcate = '$smcate' order by updatetime desc"); exit; # 인기상품\ $result_ppopu = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and ppopu = '1' and display = '1' order by updatetime desc limit 3"); @mysql_data_seek($result_ppopu[result],0); $r_ppopu = @mysql_fetch_array($result_ppopu[result]); @mysql_data_seek($result_ppopu[result],1); $r2_ppopu = @mysql_fetch_array($result_ppopu[result]); @mysql_data_seek($result_ppopu[result],2); $r3_ppopu = @mysql_fetch_array($result_ppopu[result]); $pname_ppopu = $r_ppopu[pname]; $pname2_ppopu = $r2_ppopu[pname]; $pname3_ppopu = $r3_ppopu[pname]; // echo $bigcate."
".$smcate."
".$thirdcate; exit; ?>
 
$PresentTitle");?> $PresendSmcate");?> 상품수 : 개
$r[smcatename] "; else $SMTITLE = "$r[smcatename]"; ?>
$PresentTitle");?> $PresendSmcate");?> $PresendThirdcate");?> 상품수 : 개
 
$r[smcatename] "; else $SMTITLE = "$r[smcatename]"; ?>
 
  $r[thirdcatename] "; else $THIRDTITLE = "$r[thirdcatename]"; ?>
 
"; else $STOCK_IMG = ""; if($r2[stock_amount]<1) $STOCK_IMG2 = ""; else $STOCK_IMG2 = ""; if($r3[stock_amount]<1) $STOCK_IMG3 = ""; else $STOCK_IMG3 = ""; if($r4[stock_amount]<1) $STOCK_IMG4 = ""; else $STOCK_IMG4 = ""; ?>
0 && $img_info[1] > 0){ if($img_info[0]>=$img_info[1]){ $small_width = $img_size; $small_height = $small_width*$img_info[1]/$img_info[0]; }else{ $small_height = $img_size; $small_width = $small_height*$img_info[0]/$img_info[1]; } }else{ $small_height = $img_size; $small_width = $img_size; } ?> "> <?echo($pname);?> <?echo($pname);?>
"> [".$client."]"?>
str_cutstring($pname, 36);?>
str_cutstring($eng_pname, 36);?>
$r[psellprice]){ echo("".number_format($r[pprice])."원
"); } ?> ">원

0) {?> (적립금 : 원)
0 && $img_info[1] > 0){ if($img_info[0]>=$img_info[1]){ $small_width = $img_size; $small_height = $small_width*$img_info[1]/$img_info[0]; }else{ $small_height = $img_size; $small_width = $small_height*$img_info[0]/$img_info[1]; } }else{ $small_height = $img_size; $small_width = $img_size; } ?> "> <?echo($pname2);?> <?echo($pname2);?>
"> [".$client2."]"?>
str_cutstring($pname2, 36);?>
str_cutstring($eng_pname2, 36);?>
$r2[psellprice]){ echo("".number_format($r2[pprice])."원
"); } ?> ">원

0) {?> (적립금 : 원)
0 && $img_info[1] > 0){ if($img_info[0]>=$img_info[1]){ $small_width = $img_size; $small_height = $small_width*$img_info[1]/$img_info[0]; }else{ $small_height = $img_size; $small_width = $small_height*$img_info[0]/$img_info[1]; } }else{ $small_height = $img_size; $small_width = $img_size; } ?> "> <?echo($pname3);?> <?echo($pname3);?>
"> [".$client3."]"?>
str_cutstring($pname3, 36);?>
str_cutstring($eng_pname3, 36);?>
$r3[psellprice]){ echo("".number_format($r3[pprice])."원
"); } ?> ">원

0) {?> (적립금 : 원)
0 && $img_info[1] > 0){ if($img_info[0]>=$img_info[1]){ $small_width = $img_size; $small_height = $small_width*$img_info[1]/$img_info[0]; }else{ $small_height = $img_size; $small_width = $small_height*$img_info[0]/$img_info[1]; } }else{ $small_height = $img_size; $small_width = $img_size; } ?> "> <?echo($pname4);?> <?echo($pname4);?>
"> [".$client4."]"?>
str_cutstring($pname4, 36);?>
str_cutstring($eng_pname4, 36);?>
$r4[psellprice]){ echo("".number_format($r4[pprice])."원
"); } ?> ">원

0) {?> (적립금 : 원)