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'"); $PresentTitle = $r[bigcatename]; $PresendSmcate = $r2[smcatename]; if($smcate=="") $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and display = '1' $order"); else $result = $dalib->selectSQLAll("select * from $Table[Product] where bigcate ='$bigcate' and smcate = '$smcate' and display = '1' $order"); $rnum = $result[rnum]; } $pagingList = $paging2->pagingList("mode=$mode&bigcate=$bigcate&smcate=$smcate&smcatename=$smcatename&orname=$orname&orsun=$orsun&search=$search&find=$find",$rnum,12,10); $startRecord = $paging2->startRecord; $endRecord = $paging2->endRecord; $page = $paging2->page; $result2 = $dalib->selectSQLAll("select * from $Table[Smcategory] where bigcate = '$bigcate' order by updatetime desc"); # 인기상품\ $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]; ?>

HOME >