제목에 따옴표가 들어가면...
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++){
?>
오류 안나는 방법이 없을까요?
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 2개
$sql = "SELECT * FROM {$g4['write_prefix']}{$board['bo_3']} where wr_subject = '$subject ' order by wr_num desc";
mysql_real_escape_string 사용하시면 됩니다.