Re: FN-FORUM: Postcode Radius Search

date posted 31st March 2008 13:26



you'll need somehting lie this

$grid = 'SELECT grid_east as X, grid_north as Y
FROM tbl_postcode_info as pi
WHERE postcode = "'.$racecoursepostcode.'"';
//print $grid;
$result = mysql_query($grid);
//print ' "'.mysql_affected_rows().'"';
$result = mysql_fetch_array ($result);
$range = 1500;
$given = 'SELECT `postcode` FROM `tbl_postcode_info` WHERE `grid_east` >= '.
($result["X"] - $range).' AND `grid_east` = '.($result["Y"] - $range).
' AND `grid_north`
>
> Hi everyone,
>
> I've spent a lot of time looking at potential solutions and wanted to =
> find
> out if anyone on here can build/develop a quick and easy postcode search
> tool.
>
> I'm trialing a piece of software screen below:
>
> http://www.architecturalselect.com/assets/docs/screen.jpg
>
> this returns postcodes within a certain radius either sorted by distance =
> or
> by postcode.
>
> I currently have a 3800 db set of postcode records which holds the full
> postcode / longitude and latitude coordinates and have access to others
> which only hold the postcode in part, i.e. bs1.
>
> At the minute I don't mind if it's a separate app or a spreadsheet etc =
> but I
> would like to be able to have something that is searchable.
>
> Can anyone in here build something like this ?
>
>
>
>
> Regards,
> =A0
> Karl
>
> Karl McClelland
>
> Architectural Select Ltd.
>
> [EMAIL REMOVED]
>
> +44 (0)7894 552 671
> +44 (0)1761 410 704
> Skype | karl.mcclelland
>
> www.architecturalselect.com
>
> Registered 05985631
> Springfield Buildings | Old Mills | Paulton | Bristol | BS39 7SP
>
> A Carbon Footprint is a measure of the impact human activities have on =
> the
> environment in terms of the amount of green house gases produced, =
> measured
> in units of carbon dioxide. How big is yours? Find out, and then do
> something about it! carbonfootprint.com
> This email and any files transmitted with it are confidential and =
> intended
> solely for the use of the individual or entity to whom they are =
> addressed.
> If you have received this email in error please notify the sender.
>
> Please note that any views or opinions presented in this email are =
> solely
> those of the author and do not necessarily represent those of =
> architectural
> select.
> The recipient should check this email and any attachments for the =
> presence
> of viruses. architectural select accepts no liability for any damage =
> caused
> by any virus transmitted by this email although we take precautions, so
> should you.=20
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>