제목에 따옴표가 들어가면... > 그누4 질문답변

그누4 질문답변

그누보드4 관련 질문은 QA 로 이전됩니다. QA 그누보드4 바로가기
기존 게시물은 열람만 가능합니다.

제목에 따옴표가 들어가면... 정보

제목에 따옴표가 들어가면...

본문

SELECT * FROM g4_write_bbs_2 where wr_subject = 'Children's' order by wr_num 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 'Children's' at line 1

<?
$sql = "SELECT * FROM {$g4['write_prefix']}{$board['bo_3']} where wr_subject = '$view[wr_subject]' order by wr_num desc";
//print $sql;
$result = sql_query($sql);
for ($i=0; $row=sql_fetch_array($result); $i++){
?>

오류 안나는 방법이 없을까요?

Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, null given in /home/kagla/new-sir/old/lib/common.lib.php:2339 Stack trace: #0 /home/kagla/new-sir/old/lib/common.lib.php(2339): mysqli_fetch_assoc() #1 /home/kagla/new-sir/old/skin/board/v16/view.skin.php(795): sql_fetch_array() #2 /home/kagla/new-sir/old/bbs/view.php(403): include_once('...') #3 /home/kagla/new-sir/old/bbs/board.php(300): include_once('...') #4 {main} thrown in /home/kagla/new-sir/old/lib/common.lib.php on line 2339