I do not know where to start, the following is the current search I have, but it is single fielded. I need one that you can search through multiple fields (AND, OR) to display a result.
Anyway, here is what I have:
<html>
<head>
<title>search</title>
<script language="Javascript" type="text/javascript">
<!--
function popupArticle(filename) {
article_window = window.open( filename, "article_window", "left=110,top=30,width=675,height=480,resizable=1,scrollbars=1,toolbar=1,status=0,location=0,directories=0,menubar=1");
article_window.focus();
}
//-->
</script>
</head>
<body>
<form method=post action="index.php">
<input type="hidden" name="blnSearched" value="true">
<center>
<td align="left"><img src="images/sunlogo.jpg" width=75 height=40 alt="" border=0></td>
       <font color=#333399 size=8><b>Sun Text Archives</b></font>       
<td align="right"><img src="images/sunlinklogo.jpg" width=75 height=40 alt="" border=0></td>
</center>
<div align="center">
<table cellpadding="0" cellspacing="10" border="0" width="90%">
<tr>
<td>
<b>Keyword:</b>
<br>
<input type="text" name="strKeyword" size="25" maxlength="25">
</td>
</tr>
<tr>
<td>
<b>From:</b>
<br>
<select name="strFromMonth">
<option value="01">Month</option>
<option value="01">Any</option>
<option value="01">Jan</option>
<option value="02">Feb</option>
<option value="03">Mar</option>
<option value="04">Apr</option>
<option value="05">May</option>
<option value="06">Jun</option>
<option value="07">Jul</option>
<option value="08">Aug</option>
<option value="09">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<select name="strFromDay">
<option value="01">Day</option>
<option value="01">Any</option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="strFromYear">
<option value="1900">Year</option>
<option value="1900">Any</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
</select>
</td>
<td>
<b>To:<b>
<br>
<select name="strToMonth">
<option value="0">Month</option>
<option value="0">Any</option>
<option value="01">Jan</option>
<option value="02">Feb</option>
<option value="03">Mar</option>
<option value="04">Apr</option>
<option value="05">May</option>
<option value="06">Jun</option>
<option value="07">Jul</option>
<option value="08">Aug</option>
<option value="09">Sep</option>
<option value="10">Oct</option>
<option value="11">Nov</option>
<option value="12">Dec</option>
</select>
<select name="strToDay">
<option value="0">Day</option>
<option value="0">Any</option>
<option value="01">1</option>
<option value="02">2</option>
<option value="03">3</option>
<option value="04">4</option>
<option value="05">5</option>
<option value="06">6</option>
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="strToYear">
<option value="0">Year</option>
<option value="0">Any</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
</select>
</td>
</tr>
</table>
<br>
<input type="submit">
</div>
</form>
<?
INCLUDE SQL STATEMENT
#
include 'sql/search_select.php';
echo $message;
echo $messagemid;
LOOP THROUGH THE RECORDSET
#
for ($i=0; $i <$num_p; $i++)
{
$row = mysql_fetch_array($result);
($i+1);
echo "<tr>";
echo "<td nowrap>" . ($row[1]) . "</td>";
$headline = $row[3];
if ($headline == "na" || $headline == "")
{
$headline = " ";
}
echo "<td>" . ($headline) . "</td>";
$author = $row[2];
if ($author == "na" || $author == "")
{
$author = " ";
}
echo "<td>" . ($author) . "</td>";
$body = substr($row[4],0,300);
$lastspacepos=strrpos($body,' ');
echo "<td>";
echo substr($body,0,$lastspacepos) . "...";
echo "<div align=right><small><b><a onClick=\"popupArticle('article.php?intId=$row[0]&key=$strKeyword'); return false\" href='article.php?intId=$row[0]&key=$strKeyword' target='blank'>more >></a></b></small></div></td>";
echo "</tr>";
}
echo "$messageend";
$strBody = null;
?>
</body>
</html>
