<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18939"></HEAD>
<BODY>
<DIV><FONT size=2 face=Arial><SPAN class=463185014-19082010>I am trying to add
two search fields in my GM app. I can make each field search correctly by
themselves but not together. I have the code where the first two lines
work and when I comment out the first two and enable the second two lines, the
code works for searchval2. What I want to know is how can I use ELSE with
or without the OR statements to allow me to enable both fields for the
search?</SPAN></FONT></DIV>
<DIV><FONT size=2 face=Arial><SPAN
class=463185014-19082010></SPAN></FONT> </DIV>
<DIV><FONT size=2 face=Arial><SPAN class=463185014-19082010> if
($field == "TRS") {<BR> $rs = $conn->Execute("SELECT * FROM
Surveyor_Image_Link WHERE TRS LIKE '%".$searchval."%' ORDER BY ".$sort."
ASC");<BR>// ) if ($field2 == "DOCTYPE") {<BR>//
$rs = $conn->Execute("SELECT * FROM Surveyor_Image_Link WHERE DOCTYPE LIKE
'".$searchval2."%' ORDER BY ".$sort." ASC");<BR> } else
{<BR> echo "You have reached this page by
mistake.";<BR> }<BR></SPAN></FONT></DIV>
<DIV> </DIV>
<DIV align=left>
<P align=left><FONT size=2 face=Arial>Jim Dahl, GISP<BR>GIS
Coordinator<BR>Douglas County Public Works<BR>526 Willow Dr<BR>PO Box
398<BR>Alexandria MN 56308</FONT></P>
<P><FONT size=2 face=Arial>V 320-762-2933<BR> 320-762-2999<BR>F
320-762-2998</FONT></P></DIV>
<DIV> </DIV></BODY></HTML>