게시판 목록 오류인데 해석좀 부탁드립니다 ㅠㅠ; 정보
게시판 목록 오류인데 해석좀 부탁드립니다 ㅠㅠ;본문
오류가 나는곳의 주소를 알려주시면 더 빠르고 정확하게 답변 받을 수 있습니다.
오류 주소 : torrent.cafe24.com (자료공유실 -> 게임) 목록화면
아래 링크의 게임게시판을 계정에 업로드해서 글을 작성했는데요.
http://www.sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=69629&sca=&sfl=wr_subject&stx=%B0%D4%C0%D3&sop=and
아래의 경고메세지가 게시글 목록에 표시가 됩니다.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168
아..; 해결하고 싶은데 뭘 알아야 해결을 하는데 너무 막막하네요 ㅠㅠ
아래가 소스 화면인데요
부탁드립니다.(__) 아래쪽이 좀 정신없어서 다시; 수정해서 올립니다.
<?
if (!defined("_GNUBOARD_")) exit;
$colspan = 5;
if ($is_category) $colspan++;
if ($is_checkbox) $colspan++;
include "$board_skin_path/style.php";
$list_width = "100";
?>
<!-- 게시판 목록 시작 -->
<table width="<?=$width?>" align=center cellpadding=0 cellspacing=0>
<tr><td>
<!-- 부분나눔 열기 -->
<TABLE height="20" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align=left>
<table cellpadding=0 cellspacing=0 border=0>
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<tr><td>
<select name=sfl>
<option value='wr_subject'>게임명</option>
<option value='wr_2'>게임장르</option>
</select>
<input name=stx maxlength=15 size=20 itemname="검색어" required value='<?=$stx?>'>
<select name=sop>
<option value=and>and</option>
<option value=or>or</option>
</select>
<input type=image src="<?=$board_skin_path?>/img/btn_list_search.gif" border=0 align=absmiddle></td>
</tr>
</form>
</table>
</td>
<td align=right>
<TABLE cellpadding="0" cellspacing="0" border="0">
<tr>
<? if ($is_category) { ?><form name="fcategory" method="get"><td><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>전체</option><?=$category_option?></select></td></form><? } ?>
<td>
Total <?=number_format($total_count)?>
<? if ($rss_href) { ?><a href='<?=$rss_href?>'><img src='<?=$board_skin_path?>/img/btn_rss.gif' border=0 align=absmiddle></a><?}?>
<? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/btn_admin.gif" title="관리자" width="63" height="22" border="0" align="absmiddle"></a><?}?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- 부분나눔 닫기 -->
<!-- 부분나눔 열기 -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height=5></td></tr>
</table>
<!-- 부분나눔 닫기 -->
<!-- 제목 -->
<form name="fboardlist" method="post" style="margin:0px;">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl' value='<?=$sfl?>'>
<input type='hidden' name='stx' value='<?=$stx?>'>
<input type='hidden' name='spt' value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw' value=''>
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height="1" bgcolor="#CCCCCC"></td></tr>
<tr><td height="3" bgcolor="#F6F6F6"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<!-- 목록 -->
<? for ($i=0; $i<count($list); $i++) { ?>
<tr>
<!-- 카테고리 -->
<? if ($is_category) { ?><td><a href="<?=$list[$i][ca_name_href]?>"><span class=small style='color:#999999;'><?=$list[$i][ca_name]?></span></a></td><? } ?>
<!-- 체크박스 -->
<? if ($is_checkbox) { ?><td width=30><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<?
if($list[$i][file][0][file]){
$image = $list[$i][file][0][file];
$image= "<img src='$g4[path]/data/file/$board[bo_table]/$image' width='$list_width' border='0'>";}
if ($wr_id == $list[$i][wr_id]) // 현재위치
echo "<td align=center valign=top width=120><table align=center cellpadding='5' cellspacing='5' border='0'>
<tr><td bgcolor=#2892CF align=center>";
else
echo "<td align=center valign=top width=120><table align=center cellpadding='3' cellspacing='3' border='0'>
<tr><td bgcolor=#000000 align=center>";
?>
<a href="<?=$list[$i][href]?>" onfocus='blur()'><?=$image?></a>
</td></tr>
</table>
</td>
<!-- 여백 -->
<td width=10></td>
<td>
<style>
.cross_color1 {
color:#2381B6;
text-align:center;
vertical-align:middle;
font-size:7pt;
}
</style>
<!-- <img src="<?=$board_skin_path?>/img/sub.gif"> -->
<?
$cross_color1 = "<span class='cross_color'>▶</span>";
?>
<TABLE cellpadding="1" cellspacing="1" border="0">
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>게임명:</b> <span style='font:normal 11px tahoma; color:#777777;'><a href='<?=$list[$i][href]?>'><b><?=$list[$i][subject]?></span>
</td></tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>제작/유통:</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_3]?></span>
</td></tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><B>서비스 형태</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_1]?></span></td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>게임장르</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_2]?></span></td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><?
$row5_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
$row5_result = mysql_query($row5_sql);
$row6_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
$row6_result = mysql_query($row6_sql);
$row6 = mysql_num_rows($row6_result);
for ($r=0; $row5 = mysql_fetch_array($row5_result); $r++) {
$p5 += $row5[wr_10];
}
if ($row6 > 0) {
$total_sum5 = round($p5/$row6, 2);
$sum5 = round($p5/$row6, 1);
}
?>
<table cellpadding='0' cellspacing='0' border='0'>
<tr><td><B>게임평점</b>
<span class='star_style123'><?
if ($sum5 <= 1.0) {
echo "<span class='star_style123'>☆ </span>";
}elseif ($sum5 <= 2.0) {
echo "<span class='star_style123'>★ </span>";
}elseif ($sum5 <= 3.0) {
echo "<span class='star_style123'>★☆ </span>";
}elseif ($sum5 <= 4.0) {
echo "<span class='star_style123'>★★ </span>";
}elseif ($sum5 <= 5.0) {
echo "<span class='star_style123'>★★☆ </span>";
}elseif ($sum5 <= 6.0) {
echo "<span class='star_style123'>★★★ </span>";
}elseif ($sum5 <= 7.0) {
echo "<span class='star_style123'>★★★☆ </span>";
}elseif ($sum5 <= 8.0) {
echo "<span class='star_style123'>★★★★ </span>";
}elseif ($sum5 <= 9.0) {
echo "<span class='star_style123'>★★★★☆ </span>";
}elseif ($sum5 <= 10.0) {
echo "<span class='star_style123'>★★★★★ </span>";
}
?></span> <?=$total_sum5?> 참여인원 : <?=$row6?> 명
</td></tr>
</table>
<? unset($p5);?>
</td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td valign=top><b>권장사양</b> <span style='font:normal 11px tahoma; color:#777777;'><?=cut_str(strip_tags($list[$i][wr_content]),200,"...")?></span></td>
</tr>
</table>
</td>
</tr>
<Tr><td height=5></td></tr>
<?}?>
<!-- 게시물이 없을때 -->
<? if (count($list) == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>게시물이 없습니다.</td></tr><tr><td colspan=$colspan bgcolor='#DDDDDD' height='1'></td></tr>"; } ?>
</table>
</form>
<!-- 여백 열기 -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height="2" bgcolor="#dddddd"></td></tr>
</table>
<!-- 여백 닫기 -->
<!-- 페이지 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center" height=30 valign=bottom>
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' border=0 align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#000000\">$1</font></b>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#E15916;\">$1</font></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' border=0 align=absmiddle title='다음검색'></a>"; } ?>
</td>
</tr>
</table>
<!-- 링크 버튼, 검색 -->
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td align=right height="40">
<? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0"></a><? } ?>
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0"></a><? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0"></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0"></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0"></a>
<? } ?>
</td>
</tr>
</table>
</form>
</td></tr></table>
<script language="JavaScript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
if ('<?=$stx?>') {
document.fsearch.sfl.value = '<?=$sfl?>';
document.fsearch.sop.value = '<?=$sop?>';
}
</script>
<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw) {
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str) {
var f = document.fboardlist;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete() {
var f = document.fboardlist;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./delete_all.php";
f.submit();
}
// 선택한 게시물 복사 및 이동
function select_copy(sw) {
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
if (!check_confirm(str))
return;
var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<? } ?>
<!-- 게시판 목록 끝 -->
오류 주소 : torrent.cafe24.com (자료공유실 -> 게임) 목록화면
아래 링크의 게임게시판을 계정에 업로드해서 글을 작성했는데요.
http://www.sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=69629&sca=&sfl=wr_subject&stx=%B0%D4%C0%D3&sop=and
아래의 경고메세지가 게시글 목록에 표시가 됩니다.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168
아..; 해결하고 싶은데 뭘 알아야 해결을 하는데 너무 막막하네요 ㅠㅠ
아래가 소스 화면인데요
부탁드립니다.(__) 아래쪽이 좀 정신없어서 다시; 수정해서 올립니다.
<?
if (!defined("_GNUBOARD_")) exit;
$colspan = 5;
if ($is_category) $colspan++;
if ($is_checkbox) $colspan++;
include "$board_skin_path/style.php";
$list_width = "100";
?>
<!-- 게시판 목록 시작 -->
<table width="<?=$width?>" align=center cellpadding=0 cellspacing=0>
<tr><td>
<!-- 부분나눔 열기 -->
<TABLE height="20" width="100%" cellpadding="0" cellspacing="0" border="0">
<tr>
<td align=left>
<table cellpadding=0 cellspacing=0 border=0>
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<tr><td>
<select name=sfl>
<option value='wr_subject'>게임명</option>
<option value='wr_2'>게임장르</option>
</select>
<input name=stx maxlength=15 size=20 itemname="검색어" required value='<?=$stx?>'>
<select name=sop>
<option value=and>and</option>
<option value=or>or</option>
</select>
<input type=image src="<?=$board_skin_path?>/img/btn_list_search.gif" border=0 align=absmiddle></td>
</tr>
</form>
</table>
</td>
<td align=right>
<TABLE cellpadding="0" cellspacing="0" border="0">
<tr>
<? if ($is_category) { ?><form name="fcategory" method="get"><td><select name=sca onchange="location='<?=$category_location?>'+this.value;"><option value=''>전체</option><?=$category_option?></select></td></form><? } ?>
<td>
Total <?=number_format($total_count)?>
<? if ($rss_href) { ?><a href='<?=$rss_href?>'><img src='<?=$board_skin_path?>/img/btn_rss.gif' border=0 align=absmiddle></a><?}?>
<? if ($admin_href) { ?><a href="<?=$admin_href?>"><img src="<?=$board_skin_path?>/img/btn_admin.gif" title="관리자" width="63" height="22" border="0" align="absmiddle"></a><?}?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- 부분나눔 닫기 -->
<!-- 부분나눔 열기 -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height=5></td></tr>
</table>
<!-- 부분나눔 닫기 -->
<!-- 제목 -->
<form name="fboardlist" method="post" style="margin:0px;">
<input type='hidden' name='bo_table' value='<?=$bo_table?>'>
<input type='hidden' name='sfl' value='<?=$sfl?>'>
<input type='hidden' name='stx' value='<?=$stx?>'>
<input type='hidden' name='spt' value='<?=$spt?>'>
<input type='hidden' name='page' value='<?=$page?>'>
<input type='hidden' name='sw' value=''>
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height="1" bgcolor="#CCCCCC"></td></tr>
<tr><td height="3" bgcolor="#F6F6F6"></td></tr>
</table>
<table border="0" cellpadding="0" cellspacing="0">
<!-- 목록 -->
<? for ($i=0; $i<count($list); $i++) { ?>
<tr>
<!-- 카테고리 -->
<? if ($is_category) { ?><td><a href="<?=$list[$i][ca_name_href]?>"><span class=small style='color:#999999;'><?=$list[$i][ca_name]?></span></a></td><? } ?>
<!-- 체크박스 -->
<? if ($is_checkbox) { ?><td width=30><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<?
if($list[$i][file][0][file]){
$image = $list[$i][file][0][file];
$image= "<img src='$g4[path]/data/file/$board[bo_table]/$image' width='$list_width' border='0'>";}
if ($wr_id == $list[$i][wr_id]) // 현재위치
echo "<td align=center valign=top width=120><table align=center cellpadding='5' cellspacing='5' border='0'>
<tr><td bgcolor=#2892CF align=center>";
else
echo "<td align=center valign=top width=120><table align=center cellpadding='3' cellspacing='3' border='0'>
<tr><td bgcolor=#000000 align=center>";
?>
<a href="<?=$list[$i][href]?>" onfocus='blur()'><?=$image?></a>
</td></tr>
</table>
</td>
<!-- 여백 -->
<td width=10></td>
<td>
<style>
.cross_color1 {
color:#2381B6;
text-align:center;
vertical-align:middle;
font-size:7pt;
}
</style>
<!-- <img src="<?=$board_skin_path?>/img/sub.gif"> -->
<?
$cross_color1 = "<span class='cross_color'>▶</span>";
?>
<TABLE cellpadding="1" cellspacing="1" border="0">
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>게임명:</b> <span style='font:normal 11px tahoma; color:#777777;'><a href='<?=$list[$i][href]?>'><b><?=$list[$i][subject]?></span>
</td></tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>제작/유통:</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_3]?></span>
</td></tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><B>서비스 형태</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_1]?></span></td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><b>게임장르</b> <span style='font:normal 11px tahoma; color:#777777;'><?=$list[$i][wr_2]?></span></td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td><?
$row5_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
$row5_result = mysql_query($row5_sql);
$row6_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
$row6_result = mysql_query($row6_sql);
$row6 = mysql_num_rows($row6_result);
for ($r=0; $row5 = mysql_fetch_array($row5_result); $r++) {
$p5 += $row5[wr_10];
}
if ($row6 > 0) {
$total_sum5 = round($p5/$row6, 2);
$sum5 = round($p5/$row6, 1);
}
?>
<table cellpadding='0' cellspacing='0' border='0'>
<tr><td><B>게임평점</b>
<span class='star_style123'><?
if ($sum5 <= 1.0) {
echo "<span class='star_style123'>☆ </span>";
}elseif ($sum5 <= 2.0) {
echo "<span class='star_style123'>★ </span>";
}elseif ($sum5 <= 3.0) {
echo "<span class='star_style123'>★☆ </span>";
}elseif ($sum5 <= 4.0) {
echo "<span class='star_style123'>★★ </span>";
}elseif ($sum5 <= 5.0) {
echo "<span class='star_style123'>★★☆ </span>";
}elseif ($sum5 <= 6.0) {
echo "<span class='star_style123'>★★★ </span>";
}elseif ($sum5 <= 7.0) {
echo "<span class='star_style123'>★★★☆ </span>";
}elseif ($sum5 <= 8.0) {
echo "<span class='star_style123'>★★★★ </span>";
}elseif ($sum5 <= 9.0) {
echo "<span class='star_style123'>★★★★☆ </span>";
}elseif ($sum5 <= 10.0) {
echo "<span class='star_style123'>★★★★★ </span>";
}
?></span> <?=$total_sum5?> 참여인원 : <?=$row6?> 명
</td></tr>
</table>
<? unset($p5);?>
</td>
</tr>
<tr>
<td valign=top><?=$cross_color1?> </td>
<td valign=top><b>권장사양</b> <span style='font:normal 11px tahoma; color:#777777;'><?=cut_str(strip_tags($list[$i][wr_content]),200,"...")?></span></td>
</tr>
</table>
</td>
</tr>
<Tr><td height=5></td></tr>
<?}?>
<!-- 게시물이 없을때 -->
<? if (count($list) == 0) { echo "<tr><td colspan='$colspan' height=100 align=center>게시물이 없습니다.</td></tr><tr><td colspan=$colspan bgcolor='#DDDDDD' height='1'></td></tr>"; } ?>
</table>
</form>
<!-- 여백 열기 -->
<TABLE width="100%" cellpadding="0" cellspacing="0" border="0">
<tr><td height="2" bgcolor="#dddddd"></td></tr>
</table>
<!-- 여백 닫기 -->
<!-- 페이지 -->
<table width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" align="center" height=30 valign=bottom>
<? if ($prev_part_href) { echo "<a href='$prev_part_href'><img src='$board_skin_path/img/btn_search_prev.gif' border=0 align=absmiddle title='이전검색'></a>"; } ?>
<?
// 기본으로 넘어오는 페이지를 아래와 같이 변환하여 이미지로도 출력할 수 있습니다.
//echo $write_pages;
$write_pages = str_replace("처음", "<img src='$board_skin_path/img/begin.gif' border='0' align='absmiddle' title='처음'>", $write_pages);
$write_pages = str_replace("이전", "<img src='$board_skin_path/img/prev.gif' border='0' align='absmiddle' title='이전'>", $write_pages);
$write_pages = str_replace("다음", "<img src='$board_skin_path/img/next.gif' border='0' align='absmiddle' title='다음'>", $write_pages);
$write_pages = str_replace("맨끝", "<img src='$board_skin_path/img/end.gif' border='0' align='absmiddle' title='맨끝'>", $write_pages);
$write_pages = preg_replace("/<span>([0-9]*)<\/span>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#000000\">$1</font></b>", $write_pages);
$write_pages = preg_replace("/<b>([0-9]*)<\/b>/", "<b><font style=\"font-family:tahoma; font-size:11px; color:#E15916;\">$1</font></b>", $write_pages);
?>
<?=$write_pages?>
<? if ($next_part_href) { echo "<a href='$next_part_href'><img src='$board_skin_path/img/btn_search_next.gif' border=0 align=absmiddle title='다음검색'></a>"; } ?>
</td>
</tr>
</table>
<!-- 링크 버튼, 검색 -->
<form name=fsearch method=get style="margin:0px;">
<input type=hidden name=bo_table value="<?=$bo_table?>">
<input type=hidden name=sca value="<?=$sca?>">
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td align=right height="40">
<? if ($list_href) { ?><a href="<?=$list_href?>"><img src="<?=$board_skin_path?>/img/btn_list.gif" border="0"></a><? } ?>
<? if ($write_href) { ?><a href="<?=$write_href?>"><img src="<?=$board_skin_path?>/img/btn_write.gif" border="0"></a><? } ?>
<? if ($is_checkbox) { ?>
<a href="javascript:select_delete();"><img src="<?=$board_skin_path?>/img/btn_select_delete.gif" border="0"></a>
<a href="javascript:select_copy('copy');"><img src="<?=$board_skin_path?>/img/btn_select_copy.gif" border="0"></a>
<a href="javascript:select_copy('move');"><img src="<?=$board_skin_path?>/img/btn_select_move.gif" border="0"></a>
<? } ?>
</td>
</tr>
</table>
</form>
</td></tr></table>
<script language="JavaScript">
if ('<?=$sca?>') document.fcategory.sca.value = '<?=$sca?>';
if ('<?=$stx?>') {
document.fsearch.sfl.value = '<?=$sfl?>';
document.fsearch.sop.value = '<?=$sop?>';
}
</script>
<? if ($is_checkbox) { ?>
<script language="JavaScript">
function all_checked(sw) {
var f = document.fboardlist;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]")
f.elements[i].checked = sw;
}
}
function check_confirm(str) {
var f = document.fboardlist;
var chk_count = 0;
for (var i=0; i<f.length; i++) {
if (f.elements[i].name == "chk_wr_id[]" && f.elements[i].checked)
chk_count++;
}
if (!chk_count) {
alert(str + "할 게시물을 하나 이상 선택하세요.");
return false;
}
return true;
}
// 선택한 게시물 삭제
function select_delete() {
var f = document.fboardlist;
str = "삭제";
if (!check_confirm(str))
return;
if (!confirm("선택한 게시물을 정말 "+str+" 하시겠습니까?\n\n한번 "+str+"한 자료는 복구할 수 없습니다"))
return;
f.action = "./delete_all.php";
f.submit();
}
// 선택한 게시물 복사 및 이동
function select_copy(sw) {
var f = document.fboardlist;
if (sw == "copy")
str = "복사";
else
str = "이동";
if (!check_confirm(str))
return;
var sub_win = window.open("", "move", "left=50, top=50, width=500, height=550, scrollbars=1");
f.sw.value = sw;
f.target = "move";
f.action = "./move.php";
f.submit();
}
</script>
<? } ?>
<!-- 게시판 목록 끝 -->
댓글 전체

$row5_sql = " SELECT wr_10 FROM g4_write_movie where wr_is_comment = '1' and wr_parent = '{$list[$i][wr_id]}' order by wr_10 ";
$row5_result = mysql_query($row5_sql);
이거 다음에
echo mysql_error();
를 적어 보세요. query문에 무슨 에러가 있는지 보세요.
$row5_result = mysql_query($row5_sql);
이거 다음에
echo mysql_error();
를 적어 보세요. query문에 무슨 에러가 있는지 보세요.
Table 'torrent.g4_write_movie' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168
라고 나옵니다^^;;
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 164
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hosting_users/torrent/www/skin/board/game/list.skin.php on line 168
라고 나옵니다^^;;

movie라는 게시판을 만들지 않았나 보네요.