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

Martin Burns martin at easyweb.co.uk
Thu Nov 18 15:55:46 CST 2010

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...


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

More information about the thelist mailing list