## Distance calculation based on multiple locations including starting/ finish point

I would like to calculate the total distance of driving beetween multiple locations (loop), including the distance (starting point (garage) - first location sarting point) and (last location finishig point - finishing point (garage)). Example: (Garage + D1) + (D1 + D2) + (D2 + E1) + (E1 + E2) + E2 + Garage)

I'm having a problem with the correct looping. Here's my simplified code:

PHP Code:
``` <?\$driver = 5;     \$result2 = mysql_query("SELECT * FROM test WHERE id='\$driver' LIMIT 1") or die(mysql_error());     while(\$row2 = mysql_fetch_array( \$result2 )) {         \$lon=\$row2['lon'];         \$lat=\$row2['lat'];    echo "\$lon, \$lat";     }   \$result = mysql_query("SELECT * FROM test1 WHERE driver='\$driver'") or die(mysql_error());      while(\$row = mysql_fetch_array( \$result )) {         \$lon1=\$row['lon1'];         \$lat1=\$row['lat1'];         \$lon2=\$row['lon2'];         \$lat2=\$row['lat2'];        //////////  distance between driver address and starting address            \$distancecalc = (3958*3.1415926*sqrt((\$lat-\$lat1)*(\$lat-\$lat1) + cos(\$lat/57.29578)*cos(\$lat1/57.29578)*(\$lon-\$lon1)*(\$lon-\$lon1))/180);        //////////  distance between statring address and finishing address  - multiple adsresses        \$distancecalc1 = \$distancecalc1 + (3958*3.1415926*sqrt((\$lat2-\$lat1)*(\$lat2-\$lat1) + cos(\$lat2/57.29578)*cos(\$lat1/57.29578)*(\$lon2-\$lon1)*(\$lon2-\$lon1))/180);        //////////  distance between finishing address and driver address        \$distancecalc2 = (3958*3.1415926*sqrt((\$lat2-\$lat)*(\$lat2-\$lat) + cos(\$lat2/57.29578)*cos(\$lat/57.29578)*(\$lon2-\$lon)*(\$lon2-\$lon))/180);        \$distancetotal = \$distancecalc + \$distancecalc1 +\$distancecalc2;        echo "\$distancecalc<br>        \$distancecalc1<br>        \$distancecalc2<br>";    }    echo "\$distancetotal";  ?> ```
I'm aware that code posted above doesnt't do what it meant to .. i just want to keep it clear.. there is some things i tried but no correct resoults.

I would appreciate some help on this one.

Thank you very much.