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.