영카트 select 내용에따라 검색하기 채택완료

</p>

<p><!-- <input type="checkbox" name="qname" id="ssch_qname" value="1" <?php echo $qname_check?'checked="checked"':'';?>> <label for="ssch_qname">상품명</label>

            <input type="checkbox" name="qexplan" id="ssch_qexplan" value="1" <?php echo $qexplan_check?'checked="checked"':'';?>> <label for="ssch_qexplan">상품설명</label>

            <input type="checkbox" name="qid" id="ssch_qid" value="1" <?php echo $qid_check?'checked="checked"':'';?>> <label for="ssch_qid">상품코드</label>

            <input type="checkbox" name="qbasic" id="ssch_qbasic" value="1" <?php echo $qbasic_check?'checked="checked"':'';?>> <label for="ssch_qbasic">기본설명</label> --></p>

<p>

</p>

<p><select name="qname">

                <option value="">전체</option>

                <option value="qname" <?php echo (($qname=="qname")?"selected":"");?>>상품명</option>

                <option value="qmodel" <?php echo (($qname=="qmodel")?"selected":"");?>>모델명</option>

                <option value="qexplan" <?php echo (($qname=="qexplan")?"selected":"");?>>상품설명</option>

                <option value="qid" <?php echo (($qname=="qid")?"selected":"");?>>상품코드</option>

                <option value="qbasic" <?php echo (($qname=="qbasic")?"selected":"");?>>기본설명</option>

            </select></p>

<p>

</p>

<p>// 검색범위 checkbox 처리

$qname_check = false;

$qexplan_check = false;

$qid_check = false;

$qbasic_check = false;

$qmodel_check = false; //<---------------여기수정</p>

<p>if($search_all) {

    $qname_check = true;

    $qexplan_check = true;

    $qid_check = true;

    $qbasic_check = true;

} else {

    //<---------------여기수정

    if($qname=="qname"){

        $qname_check = true;

    }

    else if($qname=="qmodel"){

        $qmodel_check = true;

    }

    else if($qname=="qexplan"){

        $qexplan_check = true;

    }

    else if($qname=="qid"){

        $qid_check = true;

    }

    else if($qname=="qbasic"){

        $qbasic_check = true;

    }</p>

<p>    /* 주석처리

    if($qname)

        $qname_check = true;

    if($qexplan)

        $qexplan_check = true;

    if($qid)

        

    if($qbasic)

        

    */

}</p>

<p>if ($q) {

    $arr = explode(" ", $q);

    $detail_where = array();

    for ($i=0; $i<count($arr); $i++) {

        $word = trim($arr[$i]);

        if (!$word) continue;</p>

<p>        $concat = array();

        if ($search_all || $qname)

            $concat[] = "a.it_name";

        if ($search_all || $qmodel){//<---------------여기변경

            $concat[] = "a.it_model";

        }

        if ($search_all || $qexplan)

            $concat[] = "a.it_explan2";

        if ($search_all || $qid)

            $concat[] = "a.it_id";

        if ($search_all || $qbasic)

            $concat[] = "a.it_basic";

        $concat_fields = "concat(".implode(",' ',",$concat).")";</p>

<p>        $detail_where[] = $concat_fields." like '%$word%' ";</p>

<p>        // 인기검색어

        insert_popular($concat, $word);

    }</p>

<p>    $where[] = "(".implode(" and ", $detail_where).")";

}</p>

<p>