[thelist] Sorting Long and Lat in Mysql...
beertastic at gmail.com
Wed Nov 24 00:10:19 CST 2010
Yeah, that's not quite what I at m after...
I ended up using a PHP loop..
throwing in limited SQL queries where appropriate..
HAppy to share the code if required...
On 18 November 2010 21:55, Martin Burns <martin at easyweb.co.uk> wrote:
> 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
> * * Please support the community that supports you. * *
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
"The only people who don't make mistakes are those who don't do anything"
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
`We are what we pretend to be, so we must be careful what we pretend to be.`
`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
More information about the thelist