Passing variables to a php script ???

[Anon]

Hello...I have a form that passes three variables to this .php script CaseNo, Initials and PartyName. I have built a query to handle one but I need to query to handle CaseNo or Initials or PartyName and if nothing is found print out on the results screen not data found. I have tried numerous attempts and have failed so any help would be gratefull.......

Frustrated.....
~~~~~~~~~~Code Below~~~~~~~~~~

<?PHP

$connection=mysql_connect (localhost, user, pass);
if($connection ==false) {
echo mysql_errno().":".mysql_error()."<br>";
exit;
}

$query="Select case.CaseNo,case.CaseName,case.DateFiled,case.DateTermed,
case.DateReopen,judge.Initials,party.PartyName,party.PartyType
from case, judge, party
where CaseNo like '$CaseNo'and aocode=judge.ao_code and CaseNo=party.CaseNum";
$result=mysql_db_query("fichedb",$query);

if ($result) {

$numOFRows=mysql_num_rows($result);
for($i=0;$i<$numOFRows; $i++){
$CaseNo=mysql_result($result, $i, "CaseNo");
$CaseName=mysql_result($result, $i, "CaseName");
$DateFiled=mysql_result($result, $i, "DateFiled");
$DateTermed=mysql_result($result, $i, "DateTermed");
$DateReopen=mysql_result($result, $i, "DateReopen");
$PartyName=mysql_result($result, $i, "PartyName");
$PartyType=mysql_result($result, $i, "PartyType");
$Initials=mysql_result($result, $i, "Initials");

echo "<table border=2 width=98%>";
echo "<tr><td width=10%>$CaseNo</td><td width=15%>$CaseName</td><td width=12%>$DateFiled</td><td width=12%>$DateTermed</td><td width=12%>$DateReopen</td><td width=9$>$PartyName</td><td width=13%>$PartyType</td><td width=13%>$Initials</td>
</tr>";
}
echo "</table>";
}
else{
echo mysql_errno().":".mysql_error()."<BR>";
}
mysql_close();

?>
</BODY>

[Anon]

Your select statement is the following:

Select case.CaseNo,
case.CaseName,
case.DateFiled,
case.DateTermed,
case.DateReopen,
judge.Initials,party.
PartyName,
party.PartyType
from case, judge, party
where CaseNo like '$CaseNo' <--- I think this is the error
and aocode=judge.ao_code
and CaseNo=party.CaseNum

you should write : where CaseNo like '$CaseNo%' . Don't forget the joker char '%' with the like operator.

JBL

[Anon]

Yes.....thanks but how do I also build in the Initials and party into the statment if I use :

where CaseNo like '$CaseNo%' or Initials like '$Initials$' or partyname like '$partyname' my query runs forever and times out....I need to know how to create an or statment that will search by either the CaseNo, Initials or the partyname????