title: How to get distance (latitude and longitude) from mysql query [PHP,MySQL]
body: <p>I have this table in mysql database.
  <img src="https://i.stack.imgur.com/0ZMak.png" alt="table"></p>
  
  <p>This is my PHP file:</p>
  
  <pre><code>$user_latitude = 45.11123;
  $user_longitude = 20.33445;
  
  $query = "";
  </code></pre>
  
  <p>I want to create a query that returns the ids (of the rows in the table) in order of distance from user position($user_latitude,$user_longitude).
  I want to do this by using a MySQL query.</p>