오류좀 봐주세요~~ 정보
오류좀 봐주세요~~본문
for ($i=0; $row=mysql_fetch_array($result); $i++) {
?>
PHP Version 5.1.6
입니다...
cm_memulevel.php 파일 소스입니다
------------
<?
include_once "./_common.php";
if (!$cb[cb_id]) {
error_msg("{$cb_id} 클럽이 존재하지 않습니다.");
}
$g4[title] = "$cb[cb_name]:클럽메뉴권한관리 - $nc[nf_title]";
include_once "$g4[path]/head.sub.php";
include_once "./include/cb_style.inc.php";
$list = Array();
$sql = " select *
from $nc[tbl_mb_level]
where cb_id = '$cb[cb_id]'
order by cm_level asc ";
$result = mysql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {
$list[$i] = $row;
}
$sql = " select a.*, count(b.wr_id) as total
from $nc[tbl_menu] as a
left join $g4[write_prefix]{$cb_id} as b
on a.cn_name = b.ca_name
where cb_id = '$cb[cb_id]'
and cn_type <> 'G'
and cn_type <> 'U'
and cn_type <> 'L'
group by cn_name
order by cn_idx asc ";
$result = mysql_query($sql);
?>
<script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>
<link href="./club.css" rel="stylesheet" type="text/css">
<form name="fcmmenulevel" method="post" action="./cm_menulevel.update.php">
<input type="hidden" name="exec" value="">
<input type="hidden" name="doc" value="<?=$doc?>">
<input type="hidden" name="cb_id" value="<?=$cb[cb_id]?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" colspan="6"><strong>> 메뉴 권한 설정 </strong></td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="3" colspan="6"></td>
</tr>
<tr align="center" bgcolor="#f5f5f5">
<td width="40" class="list"><input type="checkbox" name="chkall" value="checkbox" onClick="check_all(this.form);"></td>
<td align="left" class="listsub"><strong>메뉴명</strong></td>
<td class="listsub"><strong>읽기권한</strong></td>
<td class="listsub"><strong>쓰기권한</strong></td>
<!-- td class="listsub"><strong>삭제권한</strong></td -->
<td class="listsub"><strong>게시물</strong></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="1" colspan="6"></td>
</tr>
<?
for ($i=0; $row=mysql_fetch_array($result); $i++) {
?>
<tr bgcolor="#EEEEEE">
<td height="1" colspan="6"></td>
</tr>
<tr>
<td width="40" align="center" class="list"><input type="checkbox" name="chk[]" value="<?=$i?>"><input type="hidden" name="cn_id[]" value="<?=$row[cn_id]?>"></td>
<td height="25" class="listtext"><?=$row[cn_name]?></td>
<td height="25" align="center" class="list"><select name="cn_view_level[]">
<option value="0">손님</option>
<?
$k = 0;
while ($k <= count($list) - 1) {
$selected = "";
if ($list[$k][cm_level] == $row[cn_view_level]) {
$selected = "selected";
}
echo "<option value='{$list[$k][cm_level]}' $selected>{$list[$k][ml_name]}</option>\n";
$k++;
}
?>
</select></td>
<td height="25" align="center" class="list"><select name="cn_write_level[]">
<option value="0">손님</option>
<?
$k = 0;
while ($k <= count($list) - 1) {
$selected = "";
if ($list[$k][cm_level] == $row[cn_write_level]) {
$selected = "selected";
}
echo "<option value='{$list[$k][cm_level]}' $selected>{$list[$k][ml_name]}</option>\n";
$k++;
}
?>
</select></td>
<?
/*
<td height="25" align="center" class="list"><select name="cn_del_level[]">
<option value="0">손님</option>
<?
$k = 0;
while ($k <= count($list) - 1) {
$selected = "";
if ($list[$k][cm_level] == $row[cn_del_level]) {
$selected = "selected";
}
echo "<option value='{$list[$k][cm_level]}' $selected>{$list[$k][ml_name]}</option>\n";
$k++;
}
?>
</select></td>
*/
?>
<td height="25" align="center" class="listtext"><?=$row[total]?></td>
</tr>
<? } ?>
<tr bgcolor="#CCCCCC">
<td height="2" colspan="6"></td>
</tr>
<tr align="right">
<td style="padding:5px 10px 5px 10px;" colspan="10"><a href="#" onClick="btn_check('document.fcmmenulevel', 'update');"><img src="images/btn_ok_1.gif" width="41" height="21" border="0"></a></td>
</tr>
</table>
</form>
<br><br><br><br><br><br>
<script language="JavaScript" type="text/JavaScript">
function check_all(f)
{
var chk = document.getElementsByName("chk[]");
for (i=0; i<chk.length; i++)
chk[i].checked = f.chkall.checked;
}
function btn_check(f, act)
{
f = document.fcmmenulevel;
if (act == "update") // 선택수정
{
f.exec.value = act;
str = "수정";
}
else if (act == "delete") // 선택삭제
{
f.exec.value = act;
str = "삭제";
}
else
return;
var chk = document.getElementsByName("chk[]");
var bchk = false;
for (i=0; i<chk.length; i++)
{
if (chk[i].checked)
bchk = true;
}
if (!bchk)
{
alert(str + "할 자료를 하나 이상 선택하세요.");
return;
}
if (act == "delete")
{
if (!confirm("선택한 자료를 정말 삭제 하시겠습니까?"))
return;
}
f.submit();
}
</script>
<?
include "$g4[path]/tail.sub.php";
?>
--------------------------------------
감사합니다
댓글 전체
값이 넘어가서 쿼리가 된다면 값이 제대로 넘어가지 않았거나 그런 이유로....
중간중간 echo 문으로 체크해 보세요.
클럽을 사용하지 않아 도움을 드리지 못해죄송합니다.
먼저 쓴 내용을 참고하자면 mysql_query 를 sql_query로
mysql_fetch_array 를 sql_fetch_array 로 수정하시라고 한것은
lib/common.lib.php에서 해당 sql_query 나 sql_fetch_array 의 function 정의된곳에
골뱅이(@)가 하나 붙어서 에러메세지를 죽인다나 뭐라나........^^
대충 다 시설치했습니다^^ 그랬더니 오류 안나네요~~
<?
for ($i=0; $row=mysql_fetch_array($result); $i++) {
?>
---------------------제어문 기초-------------------------
for(초기값;비교구문;증감식){ 실행될 문장 }
예) for($i=0;$i<10;$++){ echo "이렇게 하면 10번 실행됩니다";}
---------------------------------------------------------