오류해결좀 부탁드립니다. 정보
오류해결좀 부탁드립니다.본문
<?
$bo_table_00 = "luna03_01";
$f_date00_00 = $f_date00-7;
$f_year00_00 = substr($f_date00_00,0,4);
$f_mon00_00 = substr($f_date00_00,4,2);
$f_day00_00 = substr($f_date00_00,6,2);
$f_date00_01 = $f_year00_00."-".sprintf("%02d",$f_mon00_00)."-".$f_day00_00;
$sql = " select wr_id, wr_datetime, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_16 from $g4[write_prefix]$bo_table_00 where mb_id = '$member[mb_id]' and substr(wr_datetime,1,10)>='$f_date00_01' order by wr_id desc";
$result = sql_query($sql);
$total_count = mysql_num_rows($result);
if($total_count) {
?>
<tr>
<td class=write_head>견적선택<br>(선택사항)</td>
<td colspan="3" style='padding-top:7px; padding-bottom:7px;'>
<?
while ($row = sql_fetch_array($result)) {
if($row[wr_3]=="1") {
$wr_3 = "전체 커트 / ";
} else if($row[wr_3]=="2") {
$wr_3 = "일반 펌 / ";
} else if($row[wr_3]=="3") {
$wr_3 = "디자인 펌 / ";
} else if($row[wr_3]=="4") {
$wr_3 = "라인 매직 / ";
} else if($row[wr_3]=="5") {
$wr_3 = "볼륨 매직 / ";
} else if($row[wr_3]=="") {
$wr_3 = "";
}
if($row[wr_4]=="1") {
$wr_4 = "기본염색 / ";
} else if($row[wr_4]=="2") {
$wr_4 = "톤 다운 / ";
} else if($row[wr_4]=="3") {
$wr_4 = "디자인 컬러 / ";
} else if($row[wr_4]=="4") {
$wr_4 = "해나 매니큐어 컬러큐어 / ";
} else if($row[wr_4]=="") {
$wr_4 = "";
}
if($row[wr_5]=="1") {
$wr_5 = "웰라 앰플 / ";
} else if($row[wr_5]=="2") {
$wr_5 = "No.3 S.F.B / ";
} else if($row[wr_5]=="3") {
$wr_5 = "트리시스 / ";
} else if($row[wr_5]=="") {
$wr_5 = "";
}
if($row[wr_6]=="1") {
$wr_6 = "전체 커트 / ";
} else if($row[wr_6]=="2") {
$wr_6 = "앞머리 커트 / ";
} else if($row[wr_6]=="3") {
$wr_6 = "디지털 셋팅 / ";
} else if($row[wr_6]=="4") {
$wr_6 = "일반 매직셋팅 / ";
} else if($row[wr_6]=="5") {
$wr_6 = "리얼 매직 셋팅 / ";
} else if($row[wr_6]=="6") {
$wr_6 = "일반 매직 / ";
} else if($row[wr_6]=="7") {
$wr_6 = "일반 볼륨 매직 / ";
} else if($row[wr_6]=="8") {
$wr_6 = "리얼 볼륨 매직 / ";
} else if($row[wr_6]=="9") {
$wr_6 = "크리스탈 매직 / ";
} else if($row[wr_6]=="10") {
$wr_6 = "일반 펌 / ";
} else if($row[wr_6]=="11") {
$wr_6 = "트위스트 다이렉트 / ";
} else if($row[wr_6]=="") {
$wr_6 = "";
}
if($row[wr_7]=="1") {
$wr_7 = "톤 업 / ";
} else if($row[wr_7]=="2") {
$wr_7 = "톤 다운 / ";
} else if($row[wr_7]=="3") {
$wr_7 = "리터치 일반 / ";
} else if($row[wr_7]=="4") {
$wr_7 = "리터치 새치 / ";
} else if($row[wr_7]=="5") {
$wr_7 = "해나 매니큐어 컬러큐어 / ";
} else if($row[wr_7]=="") {
$wr_7 = "";
}
if($row[wr_8]=="1") {
$wr_8 = "웰라 앰플 / ";
} else if($row[wr_8]=="2") {
$wr_8 = "No.3 S.F.B / ";
} else if($row[wr_8]=="3") {
$wr_8 = "트리시스 / ";
} else if($row[wr_8]=="4") {
$wr_8 = "웰라 컬러 후처리 / ";
} else if($row[wr_8]=="") {
$wr_8 = "";
}
$wr_16 = number_format($row[wr_16])."원";
$nbsp = " ";
echo "<input type='radio' name='wr_radio' value='$row[wr_id]'> $row[wr_datetime] <br>$nbsp$nbsp$nbsp$nbsp$nbsp $wr_3 $wr_4 $wr_5 $wr_6 $wr_7 $wr_8 $wr_16<br>";
}
?>
를 해서 올렸는데
select wr_id, wr_datetime, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_16 from g4_write_luna03_01 where mb_id = 'admin' and substr(wr_datetime,1,10)>='2011-02-20' order by wr_id desc
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(wr_datetime,1,10)>='2011-02-20' order by wr_id desc' at line 1
error file : /admin/bbs/write_online.php
라고 오류가 나요 ㅠㅠ 해결이 안되네요 ㅠㅠ 제발살려주세요
다른곳에서는 잘 돌아가는데 옮겨서 올리니 오류가 버전도 같고 한데 말이죠 ㅠㅠ
$bo_table_00 = "luna03_01";
$f_date00_00 = $f_date00-7;
$f_year00_00 = substr($f_date00_00,0,4);
$f_mon00_00 = substr($f_date00_00,4,2);
$f_day00_00 = substr($f_date00_00,6,2);
$f_date00_01 = $f_year00_00."-".sprintf("%02d",$f_mon00_00)."-".$f_day00_00;
$sql = " select wr_id, wr_datetime, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_16 from $g4[write_prefix]$bo_table_00 where mb_id = '$member[mb_id]' and substr(wr_datetime,1,10)>='$f_date00_01' order by wr_id desc";
$result = sql_query($sql);
$total_count = mysql_num_rows($result);
if($total_count) {
?>
<tr>
<td class=write_head>견적선택<br>(선택사항)</td>
<td colspan="3" style='padding-top:7px; padding-bottom:7px;'>
<?
while ($row = sql_fetch_array($result)) {
if($row[wr_3]=="1") {
$wr_3 = "전체 커트 / ";
} else if($row[wr_3]=="2") {
$wr_3 = "일반 펌 / ";
} else if($row[wr_3]=="3") {
$wr_3 = "디자인 펌 / ";
} else if($row[wr_3]=="4") {
$wr_3 = "라인 매직 / ";
} else if($row[wr_3]=="5") {
$wr_3 = "볼륨 매직 / ";
} else if($row[wr_3]=="") {
$wr_3 = "";
}
if($row[wr_4]=="1") {
$wr_4 = "기본염색 / ";
} else if($row[wr_4]=="2") {
$wr_4 = "톤 다운 / ";
} else if($row[wr_4]=="3") {
$wr_4 = "디자인 컬러 / ";
} else if($row[wr_4]=="4") {
$wr_4 = "해나 매니큐어 컬러큐어 / ";
} else if($row[wr_4]=="") {
$wr_4 = "";
}
if($row[wr_5]=="1") {
$wr_5 = "웰라 앰플 / ";
} else if($row[wr_5]=="2") {
$wr_5 = "No.3 S.F.B / ";
} else if($row[wr_5]=="3") {
$wr_5 = "트리시스 / ";
} else if($row[wr_5]=="") {
$wr_5 = "";
}
if($row[wr_6]=="1") {
$wr_6 = "전체 커트 / ";
} else if($row[wr_6]=="2") {
$wr_6 = "앞머리 커트 / ";
} else if($row[wr_6]=="3") {
$wr_6 = "디지털 셋팅 / ";
} else if($row[wr_6]=="4") {
$wr_6 = "일반 매직셋팅 / ";
} else if($row[wr_6]=="5") {
$wr_6 = "리얼 매직 셋팅 / ";
} else if($row[wr_6]=="6") {
$wr_6 = "일반 매직 / ";
} else if($row[wr_6]=="7") {
$wr_6 = "일반 볼륨 매직 / ";
} else if($row[wr_6]=="8") {
$wr_6 = "리얼 볼륨 매직 / ";
} else if($row[wr_6]=="9") {
$wr_6 = "크리스탈 매직 / ";
} else if($row[wr_6]=="10") {
$wr_6 = "일반 펌 / ";
} else if($row[wr_6]=="11") {
$wr_6 = "트위스트 다이렉트 / ";
} else if($row[wr_6]=="") {
$wr_6 = "";
}
if($row[wr_7]=="1") {
$wr_7 = "톤 업 / ";
} else if($row[wr_7]=="2") {
$wr_7 = "톤 다운 / ";
} else if($row[wr_7]=="3") {
$wr_7 = "리터치 일반 / ";
} else if($row[wr_7]=="4") {
$wr_7 = "리터치 새치 / ";
} else if($row[wr_7]=="5") {
$wr_7 = "해나 매니큐어 컬러큐어 / ";
} else if($row[wr_7]=="") {
$wr_7 = "";
}
if($row[wr_8]=="1") {
$wr_8 = "웰라 앰플 / ";
} else if($row[wr_8]=="2") {
$wr_8 = "No.3 S.F.B / ";
} else if($row[wr_8]=="3") {
$wr_8 = "트리시스 / ";
} else if($row[wr_8]=="4") {
$wr_8 = "웰라 컬러 후처리 / ";
} else if($row[wr_8]=="") {
$wr_8 = "";
}
$wr_16 = number_format($row[wr_16])."원";
$nbsp = " ";
echo "<input type='radio' name='wr_radio' value='$row[wr_id]'> $row[wr_datetime] <br>$nbsp$nbsp$nbsp$nbsp$nbsp $wr_3 $wr_4 $wr_5 $wr_6 $wr_7 $wr_8 $wr_16<br>";
}
?>
를 해서 올렸는데
select wr_id, wr_datetime, wr_3, wr_4, wr_5, wr_6, wr_7, wr_8, wr_16 from g4_write_luna03_01 where mb_id = 'admin' and substr(wr_datetime,1,10)>='2011-02-20' order by wr_id desc
1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(wr_datetime,1,10)>='2011-02-20' order by wr_id desc' at line 1
error file : /admin/bbs/write_online.php
라고 오류가 나요 ㅠㅠ 해결이 안되네요 ㅠㅠ 제발살려주세요
다른곳에서는 잘 돌아가는데 옮겨서 올리니 오류가 버전도 같고 한데 말이죠 ㅠㅠ
댓글 전체
일단 해당 필드가 있는지 먼저 확인을 여분필드 16은 얼래 그누보드에 생성된 여분 필드가 아닌데 해당 테이블에 해당 필드를 추가 하셨는지요??
넵 추가 했는데도 그러네요 ㅠㅠ