When I run my php file to pull some records out of the database, now rows show up?
Any ideas?
<?php
include("utils.php");
open_db();
$adate = $_POST["arrivedate"];
$sleepers = $_POST["sleepnum"];
// echo "Arrival Date from form ".$adate."<br>";
// echo "Property that sleeps from form ".$sleepers."<br>";
//if ($adate=="") {
//}
if ($sleepers=="") {
//if ($sleepers=="") {
$sql = "SELECT * FROM properties";
} else {
$sql = "SELECT * FROM properties WHERE sleeps >= '".$sleepers."'";
echo "Searching for: ".$sleepers."<br>";
}
//echo $sql."<br>";
?>
<table width="800" border="1">
<?php
$num_rows = 0;
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
?>
<tr>
<td> <?= $row['name']; ?> </td>
<td> <?= $row['area']; ?>
<td> <?= $row['city'] ?> </td>
<td> <?= $row['county'] ?> </td>
<td> <?= $row['postcode'] ?> </td>
<td> <?= $row['sleeps'] ?> </td>
<td> <?= $row['bedrooms'] ?> </td>
</tr>
<?php
$num_rows++;
}
close_db();
?>
</table>
<?=$num_rows?> results found.