Search :-(

[Ben-Nes Michael <miki@canaan.co.il>]

I already sent this once - can any one at least can tell if this query
can be done ?

Hi

I want to make search like this (the silver suppose to be arbirity).

select code from products where name like "%silver%" or Description like
"%silver%" or Description2 like "%silver%" and shop = "1";

I tried it but it does not work.
If any one can help, please try, i was trying to solve it in many
variation for the last few days.

<FORM METHOD=POST ACTION="[process-search]">
        <INPUT TYPE=hidden NAME=mv_searchtype VALUE="sql">

        <INPUT type=text NAME=mv_searchspec VALUE="">

        <INPUT TYPE=hidden NAME=mv_range_look VALUE="price">
         <INPUT TYPE=hidden NAME=mv_range_min VALUE="100">
         <INPUT TYPE=hidden NAME=mv_range_max VALUE="300">

        <INPUT TYPE=hidden NAME=mv_search_page VALUE="res-palace">
        <input type=hidden name=mv_substring_match value="yes">

        <INPUT type=hidden NAME=mv_search_field VALUE="Name">
        <INPUT type=hidden NAME=mv_search_field VALUE="Description">
        <INPUT type=hidden NAME=mv_search_field VALUE="Description2">

<INPUT TYPE=SUBMIT VALUE="Test">
</FORM>

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--------------------------