sql 조건문 이거 잘못 썼나요? 채택완료

</p><p>// 상품명 기준 카테고리 일괄 변경 시작</p><p>if($replace_caid) {</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>if($sca) {</p><p><span class="Apple-tab-span" style="white-space:pre">		</span>$where = "where ca_id = '$sca'";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>}</p><p><span class="Apple-tab-span" style="white-space:pre">	</span>//분류 로드</p><p>$ca_list  = '<option value="">선택</option>'.PHP_EOL;</p><p>$sql = " select * from {$g5['g5_shop_category_table']} ";</p><p>if ($is_admin != 'super')</p><p>    $sql .= " where ca_mb_id = '{$member['mb_id']}' ";</p><p>$sql .= " order by ca_order, ca_id ";</p><p>$result = sql_query($sql);</p><p>for ($i=0; $row=sql_fetch_array($result); $i++)</p><p>{</p><p>    $len = strlen($row['ca_id']) / 2 - 1;</p><p>    $nbsp = '';</p><p>    for ($i=0; $i<$len; $i++) {</p><p>        $nbsp .= '   ';</p><p>    }</p><p>    $ca_list .= '<option value="'.$row['ca_id'].'">'.$nbsp.$row['ca_name'].'</option>'.PHP_EOL;</p><p>}//분류 로드 끝</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>$sql2 = "update g5_shop_item set ca_id = $ca_list where it_name like '%$reptxt%' $where";</p><p><span class="Apple-tab-span" style="white-space:pre">	</span></p><p><span class="Apple-tab-span" style="white-space:pre">	</span>sql_query($sql2);</p><p>}</p><p>// 상품명 기준 카테고리 일괄 변경 끝</p><p>

</p><p>상품명 <input type="text" name="reptxt" id="stx" class="frm_input" value="<?php echo $reptxt; ?>">을(를) </p><p> <select name="replace_caid" id="stx" style="height:25px" class="frm_input" value="<?php echo $replace_caid; ?>"></p><p>    <?php echo $ca_list; ?></p><p> </select></p><p> 으로 </p><p> <input type="submit" value="변경하기" class="btn_submit"></p><p>