SEARCH HTML TABLE in HTML

SEARCH HTML TABLE




include ('connect.php');

error_reporting(E_ALL);
ini_set('display_errors', '1');

$submit = $_GET['submit'];
$search = $_GET['search'];
$x=0;
$construct='';
$foundnum=0;

if (!$submit)
 
  echo "you didnt submit a keyword.";

else

{

if (strlen($search)<=2)

   echo "search term to short.";
 else
{
  echo " You searched for $search

---

";

  //connect to our database

 $search_exploded = explode(" ",$search);


 foreach($search_exploded as $search_each)

{

// construct query

$x++;
if ($x==1)
    $construct .= " location LIKE '%$search_each%'";
    else
    $construct .= " OR location LIKE '%$search_each%'";
   
      }

   // echo out construct
 
 $construct = "SELECT * FROM flats WHERE $construct";
 $run = mysql_query($construct);
 $foundnum = mysql_num_rows($run);


if ($foundnum==0)
  echo "No results found.";
else
{
   echo "$foundnum result found!";

 while ($runrows = mysql_fetch_assoc($run))

{

// get data

   $select = $runrows['type'];
   $title = $runrows['title'];
   $location = $runrows['location'];
   $rent = $runrows['rent'];
   $description = $runrows['description'];
   $contactEmail = $runrows['contactEmail'];
   $number = $runrows['number'];

echo "

    $title
   
    $select
   
    $rent
   
    $location
   
    $description
   
    $contactEmail
   
    $number
   

---

";

}    


      }
    }
  }


?>