wr_link2가 123인 것을찾아서 $wr_9 $wr_10 wr_is_comment를 업데이트해주려는데
값이들어가지않아서 어디가 틀렸는지 질문드립니다
Copy
<?php$wr_9 ="100";$wr_10 ="200"; wr_is_comment ="2"; wr_link2 ="123"; $sql = " update g4_write_k10 set wr_9 = '$wr_9', wr_10 = '$wr_10', wr_is_comment = '$wr_is_comment' where wr_link2 = '$wr_link2' "; ?>답변 8개 / 댓글 2개
채택된 답변
+20 포인트
아래가 사용한 소스인데 에러를못찾겟어여,,ㅜ,ㅜ
Copy
$rex= ('@<span class="num">(.+?)</span>@');preg_match_all($rex,$txt,$num); $wr_link2 = $num[0][0]; // echo = 100$name = ''; $rex2= ('@<em class="p1">(.+?)</em>@');preg_match_all($rex2,$txt,$name); $full_name = $name[0][0]; //echo = 경기도$wr_is_comment = '2'; $wr_9 = '';$wr_10 = ''; if($full_name = 경기도 ){$wr_9 = "1";$wr_10 = "0"; }elseif ($full_name = 서울){$wr_9 = "0";$wr_10 = "0"; }elseif ($full_name = 충남){$wr_9 = "0";$wr_10 = "1"; } //echo wr_9=1 wr_10=0 $sql = " update g4_write_k10 set wr_9 = '{$wr_9}', wr_10 = '{$wr_10}', wr_is_comment = '{$wr_is_comment}' where wr_link2 = '{$wr_link2}' ";감싸면 에러가나옴니다.ㅜ.ㅜ
MySQL server version for the right syntax to use near '278' at line 5
{$wr_link2} {'$wr_link2'} $wr_link2 이건에러나고.,
'$wr_link2' 이거는 에러는안나는데 값이안들가지고ㅡ.ㅡ
답변을 작성하려면 로그인이 필요합니다.