I am currently creating a dating site that is using geolocation to show user people near them. Now I am able to get everyones distance in miles and in Kilometers. However if the distance is less them a mile or kilometer it just shows a decimal and I would like to convert it to feet or meters depending on the users form of measurement. have not been able to find the mysql of doing this.
Why not just do it outside MySQL?
I prefer to keep my data in my database and my logic outside of it.
Store it in 1 form in the DB and convert it when needed.