title: How to get nearest coordinates from database in mysql?
body: <p>I have got a table with id,latitude (lat),longitude (lng),altitude (alt).
  I have some coordinates and I would like to find the closest entry in the DB.
  I used this but not yet working correctly:</p>
  
  <pre><code>SELECT lat,ABS(lat - TestCordLat), lng, ABS(lng - TestCordLng), alt AS distance
  FROM dhm200
  ORDER BY distance
  LIMIT 6
  </code></pre>
  
  <p>I have a table with the 6 nearest points displaying me the lattitude, longtitude and altitude.</p>