MiniVend Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date ][Minivend by thread ]

Problem with Coordinated Search using SQL



I am attempting to use a coordinated search with SQL to a MySQL database.  I have not been able to get it to work properly because I do not know how to get the values of the select statements to my query.  Can anyone provide some guidance please!!
 
Here is what I'm doing:
 
<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>
 
---------------
 
One of the values I'm using here comes from the previous page--included in a one click link.  I was able to do this before I started using MySQL.  Am I missing anything??
 
Thanks in advance,
 
Humberto Reyes
htreyes@earthlink.net
 

Search for: Match: Format: Sort by: