postcode lookup

[ldoozer]

Hi all

 

I am trying to develop a small postcode lookup so taht people can type in their full postcode and hit go, and they are send to a page where they see the results to see if something is happening in their area.

 

The problem is I only want to query the first part of the postcode i.e. S10 or S1 and disregard the rest.

I have a script that will format the input from the user to a standard format (http://www.braemoor.co.uk/software/postcodes.shtml) but what i need to know is how to query there database form there:

 

Would it be something like:

 

$query = "SELECT * FROM tablename WHERE LEFT(PostCode, LENGTH(PostCode ) - 3 )IN('$postcode')";

 

 

Many thanks

Steve

[kickstart]

Hi

 

How many postcodes do you want to check at once? If just one then:-

 

$query = "SELECT * FROM tablename WHERE PostCode LIKE '".$postcode."%')";

 

All the best

 

Keith

[ldoozer]

Thanks for the reply

 

Is there a problem with that though because it could return both S2 and S22?

[kickstart]

Hi

 

It could (which depends on whether you want S2 and S22 returned), but if you want to suppress S22 then just add a space between the first part of the postcode and the *.

 

All the best

 

Keith