sql 오류문에 대한 질문 정보
sql 오류문에 대한 질문본문
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파일 입니다.
이 스킨을 보고 적용하는데요... 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파일 입니다.
<?
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");
?>댓글 전체
_bet 테이블에 idx 칼럼을 추가해주시면됩니다
위 php 파일 맨 앞에 아래와 같이 넣어주세요
<?
sql_query(" ALTER TABLE `_bet` ADD `idx` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ", false);
?>
<?
sql_query(" ALTER TABLE `_bet` ADD `idx` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ", false);
?>