![]() |
![]() |
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
|