Hi Paul,
thanks for getting back to me.
Yes I have set up a table in the wordpress database tbl_consultants. This table contains fields:
consultantID, name, address etc
Users enter a zipcode on the home page and it is redirected to the consultant page passing a query string.
For eg: ?zipcode=2001
Each consultant has their details and is assigned to a range of zip codes which are located in a 2nd table called tbl_consultant_areas. It has fields :
consultantID, areaID and zipcode.
So I need to filter the details showing up on the page by the zipcode passed to it.
Thanks
Peter