If you're using MySQL you could use the spatial extensions and declare
your coordinate field as type 'POINT'. Then you can store the data
using the following SQL:
INSERT INTO your_table (coordinates) VALUES (PointFromText('Point(32
-81)'));
You can retrieve the latitude and longitude from the single field in
MySQL using the X(coordinates) and Y(coordinates) functions.
http://dev.mysql.com/doc/refman/4.1/en/populating-spatial-columns.html
http://dev.mysql.com/doc/refman/5.1/en/geometry-property-functions.html#function_x
http://dev.mysql.com/doc/refman/5.1/en/geometry-property-functions.html#function_y
--
You received this message because you are subscribed to the Google Groups
"Google Maps API" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-maps-api?hl=en.
