sql쿼리 업데이트 질문 채택완료

$rex= ('@<span class="num">(.+?)</span>@');</p><p>preg_match_all($rex,$txt,$num);</p><p> </p><p>$wr_link2  = $num[0][0];      // echo = 100</p><p><span style="font-size: 11pt; line-height: 1.5;">$name = '';</span> </p><p>$rex2= ('@<em class="p1">(.+?)</em>@');</p><p>preg_match_all($rex2,$txt,$<span style="font-size: 14.6667px;">name</span>);</p><p> </p><p>$full_name = $<span style="font-size: 14.6667px;">name</span>[0][0];    //echo = 경기도</p><p>$wr_is_comment = '2';       </p><p> </p><p>$wr_9 = '';</p><p>$wr_10 = '';</p><p>  </p><p>  </p><p>if($<span style="font-size: 14.6667px;">full_name</span> = 경기도 ){</p><p>$wr_9 =  "1";</p><p>$wr_10 = "0"; </p><p>}</p><p>elseif ($<span style="font-size: 14.6667px;">full_name</span> = 서울){</p><p>$wr_9 =  "0";</p><p>$wr_10 = "0"; </p><p>}</p><p>elseif ($<span style="font-size: 14.6667px;">full_name</span> = 충남){</p><p>$wr_9 =  "0";</p><p>$wr_10 = "1"; </p><p>}                                    <span style="font-size: 11pt; line-height: 1.5;"> //echo wr_9=1 wr_10=0</span></p><p><span style="font-size: 11pt; line-height: 1.5;"> </span></p><p><span style="font-size: 11pt; line-height: 1.5;"> </span></p><p><span style="font-size: 11pt; line-height: 1.5;"> </span></p><p>$sql = " update g4_write_k10 </p><p>        set wr_9 = '{$wr_9}', </p><p>        wr_10 = '{$wr_10}', </p><p>        wr_is_comment = '{$wr_is_comment}' </p><p>  where wr_link2 = '{$wr_link2}' ";