i need some help with this script. its working fine but what do i do if i want to insert it within a html script. I have tried to but it between the <head> tags but dont get the result i want, pls help.
PHP:
<?php
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 <b>$search</b><hr size='1'>";
//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!<p>";
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
<br>
$select
<br>
$rent
<br>
$location
<br>
$description
<br>
$contactEmail
<br>
$number
<hr>";
}
}
}
}
?>