SQL Coordinated Search

["Humberto T Reyes" <htreyes@earthlink.net>]

Greetings to all,

 

I am still looking for a way to conduct a coordinated search with SQL--Is this possible??  Does anyone have an idea about how I may do this.

 

I am attempting to use two drop-downs with one submit button to create a search from MySQL.

 

I'm using MV 3.14-3 and Mysql 3.22.

 

Here is a snip of my code followed by what MySQL logs:

 

----snip-----

 

<FORM action="[process-search]" method="POST">
<B><FONT color="#0000cc">Choose a manufacturer and/or styleand click go!</FONT></B><BR>
<INPUT TYPE="hidden" NAME=mv_search_map VALUE="
 mv_searchspec=search1
 mv_searchspec=search2
 mv_searchspec=search3
 mv_searchspec=search4">
<INPUT TYPE="hidden" name="mv_search_field" value="department">
<INPUT TYPE="hidden" name="mv_search_field" value="subcategory">
<INPUT TYPE="hidden" name="mv_search_field" value="manufacturer">
<INPUT TYPE="hidden" name="mv_search_field" value="style">
<SELECT name="search3">
<OPTION selected value="">All Manufacturers
<OPTION value="Manufacturer1">Manufacturer1
<OPTION value="manufacturer2">Manufaacturer2
<OPTION value="manufacturer3">Manufacturer3
</OPTION>
</SELECT>

<INPUT TYPE="hidden" name="mv_matchlimit" value="14">
<INPUT TYPE="hidden" name="mv_search_page" value="vineyard_results.html">
<INPUT TYPE="hidden" name="mv_searchtype" value="sql">
<INPUT TYPE="hidden" name="search1" value="[value choice]">
<INPUT TYPE="hidden" name="search2" value="Vines Rootstock">
<INPUT TYPE="hidden" name="mv_substring_match" value="yes">
<INPUT TYPE="hidden" name="mv_coordinate" value="yes">
<SELECT name="search4">
<OPTION value="">All Styles
<OPTION value="V shape">V Shape
<OPTION value="Standard">Standard
<OPTION value="Others">Others
</OPTION>
</SELECT>
<INPUT alt="search again" border=0 height=15 name=imagefield src="/simple/images/go_1.gif" type=image width=31>
</FORM>

 

----snip----

 

----MySQL log----

 

991213  9:19:41      85 Connect    xxxxx@localhost on xxxx
                     85 Query      select code from products where 1 = 1
                     85 Query      select * from products where code =
'02-0200'
                     85 Query      select * from products where code =
'02-0201'
                     85 Query      select * from products where code =
'02-0202'
                     85 Query      select * from products where code =
'02-0203'
                     85 Query      select * from products where code =
'02-0204'
                     85 Query      select * from products where code =
'02-0205'
                     85 Query      select * from products where code =
'02-0206'
                     85 Query      select * from products where code =
'02-0207'
                     85 Query      select * from products where code =
'02-0208'
                     85 Query      select * from products where code =
'02-0209'
                     85 Query      select * from products where code =
'02-0210'
                     85 Query      select * from products where code =
'02-0211'
                     85 Query      select * from products where code =
'02-0212'
                     85 Query      select * from products where code =
'02-0213'
991213  9:19:42      85 Quit

-----end log---

 

Could someone please point me in the right direction...

 

THank you in advence,

 

Humberto Reyes

htreyes@earthlink.net