폼에서 글이 작성될 페이지를 찾지 못합니다. 채택완료
bismute
11년 전
조회 4,180
상담 폼에서 글을 작성하면 게시판에 글이 작성되도록 하는 중인데,
상담 폼에서 글을 작성하면 자꾸
select MD5(CONCAT(wr_ip, wr_subject, wr_content)) as prev_md5 from order by wr_id desc limit 1
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 'order by wr_id desc limit 1' at line 1
error file : /bbs/write_update.php
에러가 발생됩니다. 이 에러가 지정된 테이블이 없어서 발생되는 건 알겠는데
이 에러를 해결하려면 어떻게 해야 하는지 다른 분들께 여쭤보려고 이렇게 글을 올려봅니다.
</p>
<p><form name="request_write" id="request_write" method="post" style="margin:0px;"></p>
<p><input type=hidden name=null id="re_null"></p>
<p>
</p>
<p><input type=hidden name=w id="w" value=""></p>
<p><input type=hidden name=bo_table id="re_bo_table" value="req"></p>
<p><input type=hidden name=wr_id id="re_wr_id" value="<?=$wr_id?>"></p>
<p><input type=hidden name=sca id="re_sca" value="<?=$sca?>"></p>
<p><input type=hidden name=sfl id="re_sfl" value="<?=$sfl?>"></p>
<p><input type=hidden name=stx id="re_stx" value="<?=$stx?>"></p>
<p><input type=hidden name=spt id="re_spt" value="<?=$spt?>"></p>
<p><input type=hidden name=sst id="re_sstl" value="<?=$sst?>"></p>
<p><input type=hidden name=sod id="re_sod" value="<?=$sod?>"></p>
<p><input type=hidden name=page id="re_page" value="<?=$page?>"></p>
<p><input type=hidden name=wr_key id="re_wr_key" value="<?=get_session("captcha_keystring")?>"></p>
<p><input type=hidden name=returl id="re_returl" value="<?=$returl?>"></p>
<p><input type=hidden name=wr_2<span class="Apple-tab-span" style="white-space: pre"> </span> id="re_wr_2" value=""></p>
<p><input type="hidden" name="ca_name" id="re_ca_name" value="상담신청" /></p>
<p><input type="hidden" name="wr_6" id="re_wr_6" value="서브페이지" /></p>
<p><input type=hidden name=wr_subject id="re_wr_subject" itemname="제목" required value="상담신청"></p>
<p>
</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:50px;height:22px;float:left;padding-left:30px; ">이름</li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:200px;height:22px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><?</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(!$member['mb_name']) {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>?><input name="wr_name" type="text" id="re_wr_name" size="10" style="width:140px;"/><?</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>} else {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>?><input type="text" name="wr_name" id="re_wr_name" value="<?=$member['mb_name']?>" readonly="readonly" /><?</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>?></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:50px;height:22px;float:left;padding-left:30px; ">희망요일</li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:200px;height:22px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><select name="wr_3" id="re_wr_3" style="width:196px;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="선택해주세요">선택해주세요</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="월">월</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="화">화</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="수">수</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="목">목</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="금">금</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></select></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:50px;height:22px;float:left;padding-left:30px; ">연락처</li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:50px;height:22px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><select name="wr_2_1" type="text" id="re_wr_2_1" style="background-color:#FFFFFF; font-size:10pt; border:1px solid #C8C8C8;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="010" >010</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="011" >011</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="016" >016</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="017" >017</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="018" >018</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> <option value="019" >019</option></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> </select></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:13px;height:22px;float:left; "></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> -</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:57px;height:22px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><input name="wr_2_2" maxlength="4" type="text" id="re_wr_2_2" style="width:54px;height:16px;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:13px;height:22px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span> -</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:57px;height:35px;float:left;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><input name="wr_2_3" id="re_wr_2_3" maxlength="4" type="text" size="4" style="width:59px;height:16px;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><li style="width:314px;height:22px;float:left; text-align:center;"></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span><a href="#." onclick="request_submit()"><img src="/images/main_oder_bt.png"></a></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></li></p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span></ul></p>
<p></form></p>
<p><script></p>
<p>function request_submit() {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>var frm = document.getElementById("request_write");</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(frm.wr_name.value == "") {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>alert("이름을 입력하세요.");</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_name.focus();</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>return false;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(frm.wr_3.value == "") {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>alert("관심부위를 선택해주세요.");</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_3.focus();</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>return false;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(frm.wr_2_1.value == "") {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>alert("연락처를 입력하세요.");</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_2_1.focus();</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>return false;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(frm.wr_2_2.value == "") {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>alert("연락처를 입력하세요.");</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_2_2.focus();</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>return false;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>if(frm.wr_2_3.value == "") {</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>alert("연락처를 입력하세요.");</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_2_3.focus();</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>return false;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>}</p>
<p>
</p>
<p>
</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.wr_2.value = frm.wr_2_1.value +"-"+frm.wr_2_2.value+"-"+frm.wr_2_3.value;</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.action = "../bbs/write_update.php";</p>
<p><span class="Apple-tab-span" style="white-space: pre"> </span>frm.submit();</p>
<p>}</p>
<p></script></p>
<p>
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
답변에 대한 댓글 1개
b
bismute
11년 전
댓글을 작성하려면 로그인이 필요합니다.
11년 전
일단 테이블을 만들어야 하지 않겠어요?
관리자창에서 테이블을 생성후 from 바로 뒤에 테이블명 넣고 다시 시도해 보세요.
뭘 묻고 계신지 잘모르겠습니다.
로그인 후 평가할 수 있습니다
답변에 대한 댓글 1개
b
bismute
11년 전
테이블은 당연히 생성이 되어있구요.
폼을 통해서 보낼 때도 <input type=hidden name=bo_table id="re_bo_table" value="req">로 해서
write_update.php에 보낼 때 테이블을 명시해주고 있습니다.
그런데 실제로 함수에서는 저 테이블 변수를 잡지 못해서 글을 올린 거였습니다.
폼을 통해서 보낼 때도 <input type=hidden name=bo_table id="re_bo_table" value="req">로 해서
write_update.php에 보낼 때 테이블을 명시해주고 있습니다.
그런데 실제로 함수에서는 저 테이블 변수를 잡지 못해서 글을 올린 거였습니다.
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
어쨋든 답변 감사합니다.