http://sir.co.kr/bbs/board.php?bo_table=g4_skin&wr_id=89594&sca=&sfl=wr_subject%7C%7Cwr_content&stx=%ED%86%A0%ED%86%A0

이 스킨을 보고 적용하는데요... betting 할경우 아래와 같은 에러가 뜹니다.

select * from _bet where id = 'admin' order by idx desc limit 0, 15

1054 : Unknown column 'idx' in 'order clause'

error file : /bbs/bbs/mybet.php



문제는,field 추가가 안되어서 그런 것 같은데요..

어떻게 추가해주어야 하나요?

아래는 mybet.php파일 입니다.

[code]
<?
include_once("./_common.php");

if (!$member[mb_id])
alert_close("회원만 조회하실 수 있습니다.");

$g4[title] = $member[mb_nick] . "님의 포인트 내역";
include_once("$g4[path]/head.php");

$list = array();

$sql_common = " from _bet where id = '".mysql_escape_string($member[mb_id])."' ";
$sql_order = " order by idx desc ";

$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; // 시작 열을 구함
?>
<table width=100% cellpadding=0 cellspacing=0 border=0><tr><td bgcolor="#FFFFFF">
<?
$sum_point1 = $sum_point2 = 0;

$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
?>
<? if($row[bgc1] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc1]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<table width=100% cellpadding=0 cellspacing=3 border=0 bgcolor="#e0e0e0"><tr><td bgcolor="#FFFFFF">
<table width=100% cellpadding=0 cellspacing=1 border=0>
<tr>
<td colspan="9" height="2" bgcolor="#808080"></td>
</tr>
<tr bgcolor=#E1E1E1 align=center height="33">
<td width="120"><b>경기시작</b></td>
<td><b>종목</b></td>
<td><b>리그</b></td>
<td><b>홈팀</b></td>
<td><b>무</b></td>
<td><b>원정팀</b></td>
<td><b>상태</b></td>
<td><b>경기</b></td>
<td><b>적중</b></td>
</tr>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn1] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn1] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn1] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc2] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc2]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn2] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn2] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn2] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc3] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc3]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn3] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn3] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn3] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc4] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc4]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn4] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn4] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn4] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc5] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc5]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn5] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn5] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn5] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc6] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc6]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn6] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn6] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn6] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc7] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc7]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn7] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn7] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn7] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc8] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc8]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn8] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn8] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn8] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc9] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc9]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn9] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn9] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn9] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<? if($row[bgc10] != "0") { ?>
<?
$sql1 = "select * FROM g4_write_$row[bo_table] where wr_id = '$row[bgc10]' and wr_reply = '' and wr_is_comment = '0' ";
$row1 = sql_fetch($sql1);
?>
<tr align=center height="33">
<td><?=$row1[wr_1]?></td>
<td><?=$row1[ca_name]?></td>
<td><?=$row1[wr_subject]?></td>
<td style="color:#FFFFFF; padding-right:10px;" align="right" <? if($row[tn10] == "1") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_3]?>   <?=$row1[wr_4]?></td>
<td style="color:#FFFFFF;" <? if($row[tn10] == "2") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_6]?></td>
<td style="color:#FFFFFF; padding-left:10px;" align="left" <? if($row[tn10] == "3") { echo "bgcolor='#cc3333'"; } else { echo "bgcolor='#313131'"; } ?>><?=$row1[wr_7]?>   <?=$row1[wr_6]?></td>
<td>마감</td>
<td>1:1</td>
<td>적중</td>
</tr>
<? } ?>
<tr>
<td height="1" colspan="9" bgcolor="#808080"></td>
</tr>
<tr>
<td colspan="9">
<table cellpadding=1 cellspacing=1>
<tr height="40">
<td style="padding:10px;">예상배당률 : <b><?=$row[betr]?></td>
<td style="padding:10px;">배팅금액 : <b><?=number_format($row[betm])?>원</td>
<td style="padding:10px;">예상배당금 : <b><?=number_format($row[betdm])?>원</td>
<td style="padding:10px;">확정배당금 : <b>0</td>
</tr>
</table>
</td>
</tr>
</table>
</td></tr></table><br><br>
<?
// }
}
?>
</td></tr></table>
<?/*?>
<table width='100%' cellpadding=0 cellspacing=0>
<tr><td bgcolor=#B8B7B7><img src='<?=$g4[bbs_img_path]?>/title_point.gif'></td></tr>
</table>
<br>

<table width='99%' align=center cellpadding=3 cellspacing=0 border=1 bordercolordark=#F0F0F0>
<colgroup width=130></colgroup>
<colgroup width=''></colgroup>
<colgroup width=70></colgroup>
<colgroup width=70></colgroup>
<tr height=25 bgcolor=#F9F9F9 align=center>
<td>일시</td>
<td>내용</td>
<td>지급포인트</td>
<td>사용포인트</td>
</tr>

<?
$sql = " select *
$sql_common
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++) {
$point1 = $point2 = "";
if ($row[po_point] >= 0) {
$point1 = "+" . number_format($row[po_point]);
} else {
$point2 = number_format($row[po_point]);
}

echo "
<tr height=25>
<td align=center>$row[po_datetime]</td>
<td title='$row[po_content]'><nobr style='display:block; overflow:hidden; width:200px;'> $row[po_content]</a></td>
<td align=right>$point1 </td>
<td align=right>$point2 </td>
</tr>
";
}

if ($i == 0)
echo "<tr><td colspan=4 align=center height=100>자료가 없습니다.</td></tr>";
?>
</table>

<table width='100%' cellpadding=3 cellspacing=0>
<tr><td height=45 align=center><?=get_paging($config[cf_write_pages], $page, $total_page, "$_SERVER[PHP_SELF]?$qstr&page=");?></td></tr>
</table>

<table width='99%' align=center cellpadding=1 cellspacing=0 bgcolor=#CCCCCC>
<tr>
<td>
<table width='100%' cellpadding=0 cellspacing=0 bgcolor=#F9F9F9>
<tr>
<td height=50>   <B>내 포인트 </B></td>
<td><img src='<?=$g4[bbs_img_path]?>/icon_02.gif'> 보유 포인트 : <B><?=number_format($member[mb_point])?></B></td>
</tr>
</table>
</td>
</tr>
</table>

<table width='100%' cellpadding=3 cellspacing=0>
<tr><td colspan=2 height=45 align=center><a href='javascript:window.close();'><img src='<?=$g4[bbs_img_path]?>/btn_close.gif' border=0></a></td></tr>
</table>
<?*/?>

<?
include_once("$g4[path]/tail.php");
?>[/code]