$nbsp$row[ca_name]"; } $ca_list .= ""; $where = " and "; $sql_search = ""; if ($stx != "") { if ($sfl != "") { $sql_search .= " $where $sfl like '%$stx%' "; $where = " and "; } if ($save_stx != $stx) $page = 1; } if ($sca != "") { $sql_search .= " $where (a.ca_id like '$sca%' or a.ca_id2 like '$sca%' or a.ca_id3 like '$sca%') "; } if ($sfl == "") $sfl = "it_name"; $sql_common = " from $g4[yc4_item_table] a , $g4[yc4_category_table] b where (a.ca_id = b.ca_id"; //if ($is_admin != 'super') //$sql_common .= " and b.ca_mb_id = '$member[mb_id]'"; $sql_common .= ") "; $sql_common .= $sql_search; // Å×À̺íÀÇ Àüü ·¹ÄÚµå¼ö¸¸ ¾òÀ½ $sql = " select count(*) as cnt " . $sql_common; $row = sql_fetch($sql); $total_count = $row[cnt]; $rows = $config[cf_page_rows]; $total_page = ceil($total_count / $rows); // Àüü ÆäÀÌÁö °è»ê if ($page == "") { $page = 1; } // ÆäÀÌÁö°¡ ¾øÀ¸¸é ù ÆäÀÌÁö (1 ÆäÀÌÁö) $from_record = ($page - 1) * $rows; // ½ÃÀÛ ¿­À» ±¸ÇÔ if (!$sst) { $sst = "it_time"; $sod = "desc"; } $sql_order = "order by $sst $sod"; $sql = " select * $sql_common $sql_order limit $from_record, $rows "; $result = sql_query($sql); //$qstr = "$qstr&sca=$sca&page=$page"; $qstr = "$qstr&sca=$sca&page=$page&save_stx=$stx"; //echo get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$_SERVER[QUERY_STRING]&page="); ?>
óÀ½ document.flist.sel_field.value = '$sel_field';"; ?> document.flist.sfl.value = '$sfl';"; ?> document.flist.sel_field.value = '$sel_field';"; ?> document.flist.sfl.value = '$sfl';"; ?>
"; } if ($i == 0) echo ""; ?>
»çÁø »óǰ¸í ¼±ÅÃ
".get_it_image("{$row[it_id]}_s", 70, 70)." $row[it_name] ¼±¡¡¡¡ÅÃ
ÀÚ·á°¡ ÇѰǵµ ¾ø½À´Ï´Ù.