Im trying to pull information from a database based upon what a user chooses.

basically the following script outputs nothing.

when i remove the for loop it outputs the html with no db content.

Id be grateful if someone could point out where the script is failing. Im not even sure if the sql is correct.

tia rob

/*

<body bgcolor="#FFFFFF" text="#000000"><form action="<?PHP echo($PHP_SELF); ?>" method="post">
<p>Airport Location<br>
<br>
<select class=textbox name="searchlocation">
<option >Aberdeen</option>
<option >Belfast</option>
<option >Birmingham</option>
<option >Bournemouth</option>
<option >Cardiff</option>
<option >Dublin</option>
<option >East Midlands</option>
<option >Edinburgh</option>
<option >Exeter</option>
<option >Gatwick</option>
<option >Glasgow</option>
<option >Heathrow</option>
<option >Leeds</option>
<option >Liverpool</option>
<option >London City</option>
<option >Luton</option>
<option >Manchester</option>
<option >Newcastle</option>
<option >Stansted</option>
<option >Teesside</option>

</select>
<br>
Price</p>

<p>
<select class=textbox name="searchprice">

        <option >Less than &pound;50</option>
      <option >&pound;50 - &pound;75</option>
      <option >&pound;75 - &pound;100</option>
      <option >&pound;100 +</option>
</select>

</p>
<p>Accommodation Type</p>
<p>
<select name=accommtype>

  <option><font face="Arial, Helvetica, sans-serif, Ancestory SF" color="#000099" size="2">Hotel 
  </font>
  <option><font face="Arial, Helvetica, sans-serif, Ancestory SF" color="#000099" size="2">Guest 
  House </font>
  <option><font face="Arial, Helvetica, sans-serif, Ancestory SF" color="#000099" size="2">Bed 
  & Breakfast </font>
</select>

</p>
<p>
<input type="hidden" name="beensubmitted">
</p>
<TD><br>
</TD>
<TD VALIGN="bottom">
<input CLASS=button type=submit value="Search">
</td></form>
<?

if (!$searchlocation || !$searchprice)
{
echo "You have not entered search details. Please go back and try again.";
exit;
}

$searchlocation = addslashes($searchlocation);
$searchprice = addslashes($searchprice);

$Host = "localhost";
$User = "robert";
$Password = "robert";
$DBName = "airport";

$Link = mysql_connect ($Host, $User, $Password);

@ $db = mysql_pconnect("localhost", "airport", "");

if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}

mysql_select_db("airport");
$query = "select * from hoteldetail, customers where ".$searchlocation." like hoteldetail.airport and ".$searchprice." like hoteldetail.price and ".$accommtype." like hoteldetail.e_type " ;
$result = mysql_query($query);

$num_results = mysql_num_rows($result);

echo "<p>Number of results found: ".$num_results."</p>";

for ($i=0; $i <$num_results; $i++) {
$row = mysql_fetch_array($result);
echo "<p><strong>".($i+1).". ";
echo "<table border=0 width=70%><tr bgcolor= #91DBFF><td colspan=2><font size=2 face=Arial, Helvetica, sans-serif color=#000099><b>Hotel Name;</b> $row[e_name]</font></td></tr>";
echo "<tr><td><font size=2 face=Arial, Helvetica, sans-serif color=#000099>$row[address]<br>$row[address2]<br>$row[city] $row[post_code]</font></td>
<td><font size=2 face=Arial, Helvetica, sans-serif color=#000099>Nearest Airport $row[airport]</font></td></tr>";
echo "<tr><td><font size=2 face=Arial, Helvetica, sans-serif color=#000099>$row[telephone]</td><td><a href=http://$row[webadd]>$row[webadd]</a></font></td></tr>";
echo "<tr><td colspan=2><font size=2 face=Arial, Helvetica, sans-serif color=#000099>$row[desc_1]<br><br><b>Onsite facilities:<b> $row[desc_2]</font></td></tr>";
echo "<tr bgcolor= #91DBFF><td><font size=2 face=Arial, Helvetica, sans-serif color=#000099></font></td>
<td><font size=2 face=Arial, Helvetica, sans-serif color=#000099><a href=mailto:$row[emailadd]>$row[emailadd]</a></td></font></tr>";
echo "</table> <br><b><font face=arial color=red >For security purposes your IP address has been logged as $row[ipadd]</b> </font></center> ";

}

?>

*/

    ps i have closed those <option> tags still doesnt work

      i worked it out no longer need help

        Write a Reply...