[thelist] Sorting Long and Lat in Mysql...

[Martin Burns]

On 17 Nov 2010, at 20:27, Tris wrote:

> I need to provide the SQL statement with a start long/lat position.
> They then want to receive 34 images, going south from their initial
> long reference.. once they get to -90 (the bottom of the earth) to pop
> over 1 degree to the right/East and search up to the north to 90 and
> repeat until 34 images are found.


Is that their actual requirement? Or is it 'to find the nearest 34' and they've tried to hard-specify the best way to do so?

Cos I really don't think that's the best way...

Cheers
Martin

--
> Spammers: Send me email -> yumyum at easyweb.co.uk to train my filter
> http://dspam.nuclearelephant.com/