|
|
Posted by elyob on 10/23/62 11:46
"Jimbus" <mrbiggles909@yahoo.com> wrote in message
news:WPe5g.5058$XV5.3974@fed1read10...
>> Thanks, my coordinates are currently split into "latitude" and
>> "longitude" cols, although I will also be soon using the geospatial
>> functionality in mysql. (Geomotry Point etc).
>>
>> So, should I be looking to do something like this ... ?
>>
>> while($row = mysql_fetch_assoc($result)) {
>> $data[ $row['longitude'].$row['latitude'] ][] = $row['bizname'];
>> }
>
> That's how I'd do it... concatenating the lat and long. Someone else
> replied with a 3D array solution, which might be better in terms of speed.
> Not sure about that though.
>
> Anyone have an analysis of which would be faster? A longer array key vs. a
> 3D array.
Right, now I've got that array ... how am I going to print out the results?
Sorry for my numptiness, but I usually rely on MySQL doing all the work.
In fact, perhaps I ought to look at MySQL doing all the work instead of
using an array?
Navigation:
[Reply to this message]
|