Posted by The Natural Philosopher on 11/22/07 11:32

Richard wrote:
> Hi,
>
> I wonder if you could advice me on the best solution.
>
> I will receive from my client a raw data with locations of their
> stores, which probably would look like this:
> "B&Q, Industrial Park, Huntingdon, Cambridgeshire, CB23 2KK, 01480
> 7131313"
>
> What I need to do is add to the website a location finder by typing a
> postcode. Let's say I type "CB4 1JT" or "Cambridge" where I live and I
> want to display number of nearest stores.
>
> Ideally I would like to achieve similar result to this one:
> http://www.diy.com/diy/jsp/bq/templates/content_lookup.jsp?content=/bq/stores/store_finder.jsp
>
> What would be the best approach to implement solution like that? Do I
> need to buy off-shelf solution? Which one, from your experience, is
> the best. Obviously it must support PHP.
>
> Thanks a million,
> Richard
Sounds like you need a database of postcodes and their latitude and
longitude to me..

After that its all just maths innit?

First hit on google

http://www.easypeasy.com/guides/article.php?article=64

Looks exactly what you want. PHP and Mysql as well! Who could ask for
more...

[Back to original message]