need advice on SQL

[fraser5002]

Hi i need advice on how to do something.

 

I have an sql query that returns 3 things ( lat , long and a name)

 

this works fine

 

Would i would liek to do is store these results as a 2d array and for each of these results work out the distance between the lat , longs and a base lat long ( the distance calculation i can do fine) and then sort this new array ( 4 cols now) based on this calculated distance for each entry in the array.  Im new to SQL so i would realy appreciate some help on how i go about doing these array operations

 

Cheers