Displying Data
Posted: Wed Jul 14, 2004 7:41 am
I am trying to display my search results in text boxes. Easy right? But im having a problem with my PHP Heres my code any help would be great?
?
?
Code: Select all
$searchtype =$HTTP_POST_VARS['searchtype'];
$searchterm =$HTTP_POST_VARS['searchterm'];
$conn = mysql_connect("localhost","Admin"."Admin");
mysql_select_db("test",$conn);
$sql= "select ProviderName,Dos,To_Dos,Billed,Status from info where Surname like '".$searchtype."'and Dob = '".$searchterm."'";
$result=mysql_query($sql,$conn) or die(mysql_error());
$numrs = mysql_num_rows($result);
if ($numrs == 0)
{
echo '<font color="Black"><b>Please try your search again</b></font></br></br>';
echo '<font color="red">No matching records.</br></br>';
echo '<a href ="claim-lookup.html"><font color="black">Back</font></a>';
exit;
}
echo '<font color="Black"><b>Records Found:</font><font color="red">'.strtoupper($numrs).'</p>';
?>
</td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="19">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="1" bordercolor="#477678">
</td>
<td width="627" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="1" bordercolor="#477678">
</td>
<td width="627" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="1" bordercolor="#477678">
</td>
<td width="627" align="left" bgcolor="#FFFFFF" valign="top" height="1">
<font face="Times New Roman"> </font></td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="7" bordercolor="#477678">
</td>
<td width="627" align="left" bgcolor="#FFFFFF" valign="top" height="7">
</td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="7">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="1" bordercolor="#477678">
</td>
<td width="627" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
<td width="8" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="6" bordercolor="#477678">
</td>
<td width="680" align="left" bgcolor="#FFFFFF" valign="top" height="6" colspan="2">
</td>
</tr>
<tr>
<td width="1" align="left" bgcolor="#FFFFFF" valign="top" height="1" bordercolor="#477678">
</td>
<td width="680" align="left" bgcolor="#FFFFFF" valign="top" height="1" colspan="2">
</td>
<td width="9" align="left" bgcolor="#FFFFFF" valign="top" height="1">
</td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table></center>
</div>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="57%" height="16">
<tr>
<td width="100%" height="12" bgcolor="#008080">
<p align="center"><font size="2"><font color="#FFFFFF"> View our </font>
<a href="l"><font color="#FFFFFF">Privacy Policy</font></a><font color="#FFFFFF">
for information on how we protect your privacy. </font></font></td>
</tr>
<tr>
<td width="100%" height="3" bgcolor="#008080">
<p align="center"><font face="Arial" size="1" color="#FFFFFF"> Copyright
© 2000-2003 by Electronic Health Plans, Inc. All rights reserved</font></td>
</tr>
</table>
</center>
</div>