I want to write a php program to select 16 random gps points from 400 points in my database
(point table : id - Title - latitude - longitude ).
lat 37.9824
lon -87.5781547
The only requirement 16 random points, each of which is at least 1km from each other point ( find the points that are in 1KM range )
it is a system that selects pharmacies with a minimum distance of 1 km between each pharmacy. I have 400 pharmacies in the database and every week I must select 16 pharmacies. I can not select two pharmacies very close.
example :
if the program return 3 pharmacies A B and C .
the ditance between pharmacies must be :
A and B = 1 KM
A and C = 1 KM
B and C = 1 KM