Hello,
I need your help badly. I do have a search form. It has a 3 radio button, in which its group name = R1 in which the right side of the radio buttons has a txtfield or a list/menu (please see attached code)
How do i make the name of txtfield to use a single name? so that when it passed to the result page the SQL syntax will only use the the values of R1 and the single name of the txtfields.
Any help is highly appreciated
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HEAD><TITLE>Members Search</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<SCRIPT language=javascript>
<!--
function focR(opt){
if (navigator.appName!='Netscape'){
document.all.item("category",0).style.visibility="hidden";
document.all.item("nameofcompany",0).style.visibility="hidden";
document.all.item("lineofbusiness",0).style.visibility="hidden";
document.all.item(opt,0).style.visibility="";
}
}
function checkinput(){
if (document.form.R1[1].checked){
if (document.form.nameofcompany.value == ""){
alert("Please fill in the name of company field.");
document.form.nameofcompany.focus();
return false;
}
}
else{
if (document.form.R1[2].checked){
if (document.form.lineofbusiness.value == ""){
alert("Please fill in the line of business field field.");
document.form.lineofbusiness.focus();
return false;
}
}
else{
return true;
}
}
}
//-->
</SCRIPT>
<META content=Members name=description>
<META content="MSHTML 6.00.2600.0" name=GENERATOR>
<META content=Members name=keywords>
<META content=FrontPage.Editor.Document name=ProgId>
<STYLE fprolloverstyle>A:hover {
FONT-SIZE: 10px; COLOR: #ff0000; FONT-FAMILY: Verdana
}
</STYLE>
</HEAD>
<BODY link=#07393a bgColor=#ffffff leftMargin=0 topMargin=0 marginheight="0"
marginwidth="0">
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="215" height="240" valign="top">
<div align="center">
<pre align=center><font size="2" face="Courier New, Courier, mono"><font size="4">SEARCH HERE</font></font><font size="4"> </font></pre>
</div>
<FORM action=searchresults.php method=get name=form onsubmit="return checkinput()"
align="left">
<TABLE cellSpacing=0 cellPadding=5 width="76%" border=0>
<TBODY>
<TR>
<TD width="9%"><font face="Arial"><small>
<INPUT onfocus="focR('category')" type=radio CHECKED
value=categorykey name=R1>
</small></font></TD>
<TD width="30%"><font face="Arial"><small><FONT size=2>Category</FONT></small></font></TD>
<TD width="61%"> <DIV id=category sytle="visibility:hidden"><font face="Arial"><small>
<SELECT size=1 name=category
width="100">
<OPTION value=AGRI-AQUA selected>AGRI-AQUA</OPTION>
<OPTION
value=ASSOCIATION>ASSOCIATION</OPTION>
<OPTION
value=INDUSTRY>INDUSTRY</OPTION>
<OPTION value=SERVICE>SERVICE</OPTION>
<OPTION value=TRADE>TRADE</OPTION>
<OPTION value="ALL SECTORS">ALL SECTORS</OPTION>
</SELECT>
</small></font></DIV></TD>
</TR>
<TR>
<TD width="9%"><font face="Arial"><small>
<INPUT onfocus="focR('nameofcompany')" type=radio
value=nameofcompanykey name=R1>
</small></font></TD>
<TD width="30%"><font face="Arial"><small><FONT size=2>Name of Company</FONT></small></font></TD>
<TD width="61%"> <DIV id=nameofcompany sytle="visibility:hidden"><font face="Arial"><small>
<INPUT size=18
name=nameofcompany>
</small></font></DIV></TD>
</TR>
<TR>
<TD width="9%"><font face="Arial"><small>
<INPUT onfocus="focR('lineofbusiness')" type=radio
value=lineofbusinesskey name=R1>
</small></font></TD>
<TD width="30%"><font face="Arial"><small><FONT size=2>Line of Business</FONT></small></font></TD>
<TD width="61%"> <DIV id=lineofbusiness sytle="visibility:hidden"><font face="Arial"><small>
<INPUT size=18
name=lineofbusiness>
</small></font></DIV></TD>
</TR>
</TBODY>
</TABLE>
<P align="center"><font face="Arial"><small> <FONT size=2> </FONT></small></font><font face="Arial"><small>
<input type=submit value=Search name=Submit>
</small></font></P>
</FORM>
</td>
</tr>
<tr>
<td width="215" height="1" valign="top"><img src="transparent.gif" alt="" width="215" height="1"></td>
</tr>
</table>
</BODY>