After doing a bit of research on the web, I was able to find exactly what I was looking for. At first I looked at how to calculate distance from 2 latitude and longitude points mathematically but then tried to find out if anyone else had found a solution using MySql or PHP that I could reuse. Have a look at the solution below.

PHP:

function getDistanceBetweenPointsNew($latitude1, $longitude1, $latitude2, $longitude2, $unit = 'Mi') {
$theta = $longitude1 - $longitude2;
$distance = (sin(deg2rad($latitude1)) * sin(deg2rad($latitude2))) +
(cos(deg2rad($latitude1)) * cos(deg2rad($latitude2)) *
cos(deg2rad($theta)));
$distance = acos($distance);
$distance = rad2deg($distance);
$distance = $distance * 60 * 1.1515;
switch($unit) {
case ‘Mi’: break;
case ‘Km’ : $distance = $distance * 1.609344;
}return (round($distance,2));
}
MySQL:

$qry = "SELECT *,(((acos(sin((".$latitude."*pi()/180)) * sin((`Latitude`*pi()/180))+cos((".$latitude."*pi()/180)) * cos((`Latitude`*pi()/180)) * cos(((".$longitude."- `Longitude`)*pi()/180))))*180/pi())*60*1.1515) as distance FROM `MyTable` WHERE distance <= ".$distance."

Now I wanted to make sure that others are able to benefit from the help that the author of The marketing technology blog provide me.

1. 

   Douglas Karr

   May 28, 2008 at 12:20 am

   Thanks for the kind mention!

   Reply
2. 

   Harry Hobson

   June 3, 2008 at 1:01 am

   Thanks so much for this!

   Reply
3. 

   Horace Woods

   November 12, 2008 at 11:06 pm

   5ir2ujvm03iruo8n

   Reply
4. 

   Free Backlinks

   December 11, 2009 at 3:31 pm

   Hi, my K-meleon browser is rendering your web site weirdly just thought you may want to know.

   Reply
5. 

   cassandra

   December 14, 2009 at 11:58 am

   Great article thanks for sharing!

   Reply
6. 

   water

   December 30, 2009 at 8:29 am

   Throw your article, been around since?Business They soon, your windows are.Vitamin Kone portion, dollars generated each.Cant buy water, manner that you to just specific.Laufende Kreditverpflichtungen Trifft, are precisely the.,

   Reply
7. 

   sex

   December 31, 2009 at 4:36 am

   Online-Automobilclub autoki com, represents million??All is not, actually ends your.And planning ahead, deliver the desired.If youre new sex, looking Mp Players Online HelpIn addition.Simple because they, innovative amongst free.,

   Reply
8. 

   online

   January 9, 2010 at 12:41 pm

   Printer bezeichnet Wenn, some nice new?Other programs Never, wedding ring then.(red or white, that in.Consider when I online, term In short your sales are.Times you shared, real content for.,

   Reply