[Google Maps API v2] Creating a Store Locator SQL doesn't work

Hello,

I'm trying to follow Creating a Store Locator as per
http://code.google.com/apis/maps/articles/phpsqlgeocode.html

I'm only trying to just get the SQL to work. I created the table and
populated it with the examples provided.

However, when I tried to execute the SQL that it provided: SELECT id,
( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) *
cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) *
sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance <
25 ORDER BY distance LIMIT 0 , 20;

This executed without error but returned 0 rows. I then tried to
lower the 25 mile radius to 1 mile and still it returned 0 rows.

Has anyone gotten this to work? It seems odd that Google would post
an article that doesn't work!

Cheers,
J

--
You received this message because you are subscribed to the Google Groups "Google Maps API V2" group.
To post to this group, send email to google-maps-api@googlegroups.com.
To unsubscribe from this group, send email to google-maps-api+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-maps-api?hl=en.