Posted 16 August 2006 - 09:21 AM
The postcodes are listed as WS, BB, CA, B etc.
The user types in say ws7 3uy I want the resuts to be anything related to WS.
I have this as my query:
SELECT postcodes.POSTCODE, shops.STORENAME, shops.UNITTYPE, shops.PERSILTEL, shops.PHOTOTEL, shops.ADDRESS1, shops.ADDRESS2, shops.TOWNCITY, shops.COUNTY, shops.POSTCODE, shops.EMAIL, shops.MANAGER, shops.LAUNDRY, shops.LAUNCHDATE, shops.OPENINGHOURS
FROM postcodes, shops
WHERE postcodes.POSTCODE LIKE colname% AND shops.CODE = postcodes.code
But it will only bring up my results if I type WS or BB etc. As soon as I tyoe in the full post code no result!
Any one help!
Posted 16 August 2006 - 10:04 AM
Posted 16 August 2006 - 10:26 AM
The postcode colum has example:
Posted 16 August 2006 - 11:08 AM
Posted 16 August 2006 - 11:13 AM
Some postcodes are b19 etc so it just needs to find 'b'
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users