Below is my code for a page that searches my database and produces results. It is incomplete, but searches fine atm. The only problem i am having is on displaying the page i get "<br/>" in the form input boxes. Can someone help me get rid of this??
THanks for any help
<?php include("header.inc");?>
<TABLE width="300" height="150" background="back1.jpg" align="center">
<FORM method="post" action="<? echo $_SERVER['PHP_SELF']?>">
<TR><TD>Keyword</TD><TD><input type="Text" name="Keyword" VALUE="<?echo $UserName?>"></TD></TR>
<TR><TD>Minimum Salary</TD><TD><SELECT size="1" name="Salary" VALUE="<?echo $Salary?>"/>
<option>under £10,000
<option>£10,000
<option>£15,000
<option>£20,000
<option>£25,000
<option>£30,000
<option>£40,000
<option>£50,000
<option>£60,000
<option>£70,000
<option>£80,000+
</SELECT></TD></TR>
<TR><TD>Location</TD><TD><input type="Text" name="Location" VALUE="<?echo $Location?>"></TD></TR>
<TR><TD><INPUT TYPE="Submit" name="search" VALUE="Search">
<INPUT TYPE="Reset" VALUE="Clear"/></TD></TR>
</FORM>
</TABLE>
<br>
<?
if (isset($_POST['search']) && $_POST['search'] == "Search") {
//open db connection
$link=mysqli_connect('localhost','root','voBtGM','JobBase');
$select="SELECT JobTitle, Salary, Location, Description FROM Jobs WHERE Location = '".$_POST['Location']."' AND Description LIKE '%".$_POST['Keyword']."%' OR JobTitle LIKE '%".$_POST['Keyword']."%' ";
$result=mysqli_query($link,$select);
while ($row = mysqli_fetch_array($result)) {
$Title= $row['JobTitle'];
$Sal= $row['Salary'];
$Loc= $row['Location'];
$Des=$row['Description'];?>
<TABLE BORDER="1" cellspacing="5">
<TR><TD>
<TABLE width=800 CELLPADDING="5">
<TR><TD><?echo "Job Title: $Title";?></TD></TR>
<TR><TD><?echo "Salary: $Sal";?></TD></TR>
<TR><TD><?echo "Location: $Loc";?></TD></TR>
<TR><TD><?echo "Description: $Des";?></TD></TR>
</TABLE>
</TD></TR>
</TABLE>
<?}
//set variables to "" for next form input
$JobTitle = $Salary = $Location = $Description = $Username ="";
mysqli_close($link);
}
?>
</body>
</html>
