$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] |
";
/**
if($row[id] == "free") echo"$row[head_title]";
else if($row[id] == "qna") echo"$row[head_title]";
else if($row[id] == "notice") echo"$row[head_title]";
else if($row[id] == "diary") echo"$row[head_title]";
else echo"$row[head_title]";
**/
echo"$row[head_title]";
echo"
|
$shape |
$crow[0] |
$row[skin] |
".substr($row[wdate], 0, 10)." |
¼öÁ¤";
if($row[id] != "free" && $row[id] != "qna" && $row[id] != "notice" && $row[id] != "diary") echo" / »èÁ¦";
echo"
|
|
";
}
if(!$total){
echo"
µî·Ï(°Ë»ö)µÈ °Ô½ÃÆÇÀÌ ¾ø½À´Ï´Ù. |
|
";
}
echo"
|
|
|
|
";
?>