Is there any way you know of to grab all of the stores in the stores list say in the following search form?
We are trying to make a mapping system, and can not figure out how to get complete lists. I am willing to learn.
Thanks
Our solution to a similar problem was to write a server side script in Perl.
Is there any way you know of to grab all of the stores in the stores list say in the following search form?
We are trying to make a mapping system, and can not figure out how to get complete lists. I am willing to learn. Thanks |
I used php to write one based on lattitude and longitude.
Used some sql like this
SELECT Lat, `Long` FROM poc_zipcodes WHERE Zipcode = 'enterd values'
and
SELECT *, ( 3959 * acos( cos( radians($lat) ) * cos( radians( Lat ) ) * cos( radians( `Long` ) - radians($lon) ) + sin( radians($lat) ) * sin( radians( Lat ) ) ) ) AS distance FROM view_poc_providerDist
The view contains the location of what would in your case be a store. We have a zipcode database that provides the location of the searched item in the first code box, and compares them using the second query