if(!$page)
$page=1;
$comix_per_page=10;
if($type=='all') {
if($code=="search")
$imsi_result=mysql_query("SELECT * FROM zetyx_board_chain_reply WHERE sitelink2!='1' and (subject like '%$keyword%' or memo like '%$keyword%')",$connect);
else
$imsi_result=mysql_query("select * from zetyx_board_chain_reply where sitelink2!=1",$connect);
$comix_count=mysql_num_rows($imsi_result);
if($code=="search")
$result3=mysql_query("SELECT * FROM zetyx_board_chain_reply where sitelink2!='1' and (subject like '%$keyword%' or memo like '%$keyword%') order by no desc limit ".(($page-1)*$comix_per_page).", $comix_per_page",$connect);
else
$result3=mysql_query("select * from zetyx_board_chain_reply where sitelink2!=1 order by no desc limit ".(($page-1)*$comix_per_page).", $comix_per_page",$connect);
$total3=mysql_num_rows($result3);
} else if($type=='only') {
if($code=="search")
$imsi_result=mysql_query("SELECT * FROM zetyx_board_chain_reply WHERE sitelink2='1' and (subject like '%$keyword%' or memo like '%$keyword%')",$connect);
else
$imsi_result=mysql_query("select * from zetyx_board_chain_reply where sitelink2=1",$connect);
$comix_count=mysql_num_rows($imsi_result);
if($code=="search")
$result3=mysql_query("select * from zetyx_board_chain_reply where sitelink2=1 and (subject like '%$keyword%' or memo like '%$keyword%') order by no desc limit ".(($page-1)*$comix_per_page).", $comix_per_page",$connect);
else
$result3=mysql_query("select * from zetyx_board_chain_reply where sitelink2=1 order by no desc limit ".(($page-1)*$comix_per_page).", $comix_per_page",$connect);
$total3=mysql_num_rows($result3);
}
if($code=="search") {
echo "
검색어 : $keyword (총 $comix_count 개)
검색 초기화";
}
for($i=0;$i<$total3;$i++) {
$row3=mysql_fetch_array($result3);
$answer='';
$result4=mysql_query("SELECT * FROM zetyx_board_comment_chain_reply WHERE parent='$row3[no]' ORDER BY no DESC",$connect);
$total4=mysql_num_rows($result4);
switch($row3[category]) {
case '1':
$category="만화";
$folder="img_data";
break;
case '2':
$category="만화가";
$folder="img_data2";
break;
case '3':
$category="캐릭터";
$folder="img_data3";
break;
case '4':
$category="기타";
break;
}
echo "
";
$answer=getAnswerImage($result4, $total4, $row3[category], $connect);
if($answer!='') {
echo "
";
}
if($type=="only") {
$comment_result=mysql_query("SELECT * FROM zetyx_board_comment_chain_reply WHERE answer='§※' and parent='$row3[no]' order by no",$connect);
$cntCr=$row3[total_comment]-mysql_num_rows($comment_result);
$row3[total_comment]=mysql_num_rows($comment_result);
}
echo "
".stripslashes($row3[subject])." ";
if($type=="only" && $cntCr>0) {
if($row3[category]==1)
echo "
".$cntCr."개의 $category";
else
echo "
".$cntCr."명의 $category";
} else {
echo "
[$category]";
}
echo "
".str_cut(stripslashes($row3[memo]),150)."
".$row3[r_name]."
".date("Y. m. d",$row3[reg_date])."
".$row3[total_comment]." Comments
".number_format($row3[hit])." Hits
";
}
?>