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

[Tris]

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...
>
> Cheers
> Martin
>
> --
>> Spammers: Send me email -> yumyum at easyweb.co.uk to train my filter
>> http://dspam.nuclearelephant.com/
>
>
>
>
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> 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.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz