제목에 따옴표가 들어가면... 정보
제목에 따옴표가 들어가면...본문
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++){
?>
오류 안나는 방법이 없을까요?
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++){
?>
오류 안나는 방법이 없을까요?
댓글 전체
$subject = mysql_real_escape_string($view[wr_subject]);
$sql = "SELECT * FROM {$g4['write_prefix']}{$board['bo_3']} where wr_subject = '$subject ' order by wr_num desc";
mysql_real_escape_string 사용하시면 됩니다.
$sql = "SELECT * FROM {$g4['write_prefix']}{$board['bo_3']} where wr_subject = '$subject ' order by wr_num desc";
mysql_real_escape_string 사용하시면 됩니다.
감사합니다..완벽하게 잘됩니다..