Question: Hey i have an array an I need to separate each value so it would be something like this

```
$arry = array(a,b,c,d,e,f)
$point1 = (SELECT distance FROM Table WHERE Origin = a AND Destination = b);
$point2 = (SELECT distance FROM Table WHERE Origin = b AND Destination = c);
$point3 = (SELECT distance FROM Table WHERE Origin = c AND Destination = d);
$point4 = (SELECT distance FROM Table WHERE Origin = d AND Destination = e);
$point5 = (SELECT distance FROM Table WHERE Origin = e AND Destination = f);
$point6 = (SELECT distance FROM Table WHERE Origin = f AND Destination = g);
$point7 = (SELECT distance FROM Table WHERE Origin = g AND Destination = f);

$total_trav = $point1+$point2+$point3+$point4+$point5+$point6+$point7

```

Answer: 
This could all be done in SQL:

```
SELECT SUM(distance) 
FROM table 
WHERE (origin='a' AND destination='b') 
   OR (origin='b' AND destination='c')
   OR (origin='c' AND destination='d')

```

and so forth.
use [`extract`](http://php.net/manual/en/function.extract.php) 

will extract the elements from the array to variables using the key as the name.