Jump to content

Search problem


fazzfarrell

Recommended Posts

I have set up a seach to match postcodes

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!
Link to comment
https://forums.phpfreaks.com/topic/17718-search-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.