title: SQL query, select nearest places by a given coordinates
body: <p>I have <code>$latitude = 29.6815400</code> and <code>$longitude = 64.3647100</code>, now in MySQL I would like to take the 15 nearest places to these coordinates and I'm planning to do this query:</p>
  
  <pre><code>SELECT *
  FROM places
  WHERE latitude  BETWEEN($latitude  - 1, $latitude  + 1)
  AND   longitude BETWEEN($longitude - 1, $logintude + 1)
  LIMIT 15;
  </code></pre>
  
  <p>Do you think it's correct or do you suggest something else?</p>
  
  <p>How to do the <code>BEETWEEN</code>, since I want to search trough a maximum of 50Km range the near places?</p>
  
  <p>I forgot to say that I can also use PHP for do anything before to run the query.</p>
  
  <p>Note: <strong>I can't use stored procedures</strong>.</p>