I am creating an android application where it should fetch the data from sql table. In my sql table I have latitude and longitude coordinates stored in it. And i am able to pass current location co ordinates from my application to PHP code. And now i want to fetch the records where the distance between current location coordinates and stored co-ordinates must be <= 50 kilometers. How can i do it.
I have used GET method to fetch the current position from andorid application.
Thanks in advance.