Search for Partial Postcodes

[ElectricRain]

Does anyone know how I might adjust something like this to allow users to search a database for partial postcodes (eg LA4 instead of the full 6 or 7 characters)?

if ($location ==("searchpostcode")) {
$query = ("SELECT * FROM propertys WHERE MATCH(Postcode) AGAINST ('$postcode')");
$result = mysql_query($query);
// see if any rows were returned 
if (mysql_num_rows($result) > 0) { 
    // yes 
    // print them one after another 
    echo "<table cellpadding=10 border=1>"; 
    while($row = mysql_fetch_row($result)) { 
        echo "<tr>"; 
        echo "<td>".$row[0]."</td>"; 
        echo "<td>" . $row[1]."</td>"; 
        echo "<td>".$row[2]."</td>"; 
        echo "</tr>"; 
    } 
    echo "</table>"; 
}

else { 
    // no 
    // print status message 
    echo "No records found!"; 
    } 
}

[robert_w_ark]

if($location == "searchpostcode")
{
  $result = mysql_query("SELECT * FROM propertys WHERE postcode='".$postcode."'") or die(mysql_error());
  if(mysql_num_rows($result) > 0)
  {
    echo "<table cellpadding=\"10\" border=\"1\">"; 
    while($row = mysql_fetch_row($result))
    {
      echo "<tr>\n"; 
      echo "<td>".$row[0]."</td>\n";
      echo "<td>" . $row[1]."</td>\n";
      echo "<td>".$row[2]."</td>\n";
      echo "</tr>\n";
    } 
    echo "</table>\n"; 
  }
  else echo "No records found!\n";
}

Maybe this will work.....

[ElectricRain]

Nope. It doesnt return an error, but unless the full postcode is input it doesnt return any results either.

[laserlight]

SELECT * FROM propertys WHERE Postcode LIKE '%$postcode%';

[ElectricRain]

Star! Thank you so much! 🙂