need help with a search engine script

[balam]

Hi,

i need help to make my search script more flexible. As it is now it will only give accurate result if i search the column called location but i want it to search a column called rent to. i.e notting hill £900, I have tried to change the query to

$construct = "SELECT * FROM flats WHERE location, rent =$construct";

but its not valid. heres the entire code.

<?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 rent LIKE '%$search_each%'";
    
      }

   // echo out construct
  
 $construct = "SELECT * FROM flats WHERE location, rent =$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>";

}     


      }
    }
  }


?>

 

[angelwatt]

I believe you want,

$construct = "SELECT * FROM flats WHERE $construct";

To see how the query ends up you can echo $construct out to make sure it's in proper syntax.