Does anybody know the most efficient way to attach a location to an object in the database?
I would like to allow a search for people in a certain area (as in a certain radius)
I was thinking about just letting people specify a city and state instead of sticking their coords in the database. i dont know the best way and im just looking for a good way to do this.

Any advice?

Regards!

Coords sound pretty good to me ... add a half degree to each coord - take 22N, 33W and get 22.5N, 21.5N, 33.5W, and 32.5W. Search for people with a coord inside. Something like that maybe. Is that what you're looking for?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.