$sql = "select count(id) from $admin_table ";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
$total = $row[0];
$item = $page_skip;
if(!$item) $item = 15;
$pageitem = $pagenumber;
if(!$pageitem) $pageitem = 10;
if(!$page) $page = 1;
$start = ($page - 1) * $item;
$totalpage = ceil($total / $item);
$pnum = $total - (($page-1) * $item);
$sql = "select * from $admin_table order by num desc limit $start, $item";
$res = mysql_query($sql);
echo"
°Ô½ÃÆÇ ¸®½ºÆ® |
¹øÈ£ |
¾ÆÀ̵ð |
°Ô½ÃÆÇÀ̸§ |
À¯ Çü |
°Ô½Ã¹°¼ö |
½º Ų |
»ý¼ºÀÏ |
¼öÁ¤ |
|
";
while($row = mysql_fetch_array($res)){
$csql = "select count(num) from $board_table where db='$row[id]'";
$crow = mysql_fetch_array(mysql_query($csql));
if($row[shape] == "normal") $shape = "ÀÏ¹Ý°Ô½ÃÆÇ";
else if($row[shape] == "gallery") $shape = "°Ö·¯¸®°Ô½ÃÆÇ";
else if($row[shape] == "photo") $shape = "°Ö·¯¸®¸®½ºÆ®";
echo"
".$pnum--." |
$row[id] |
$row[head_title] |
$shape |
$crow[0] |
$row[skin] |
".substr($row[wdate], 0, 10)." |
¼öÁ¤
|
|
";
}
if(!$total){
echo"
µî·Ï(°Ë»ö)µÈ °Ô½ÃÆÇÀÌ ¾ø½À´Ï´Ù. |
|
";
}
echo"
|
|
|
";
$fquery = "ipg=$ipg&lcode=$lcode&mcode=$mcode&scode=$scode&pm=$pm";
psk_pagelinkB($totalpage, $pageitem, $page, "../images/inc/i_prev.gif", "../images/inc/i_next.gif", $fquery);
echo"
|
|
|
|
";
?>