Here is the sql sentence i wrote on my php file.
But when i test with it nothing show up which there should have some results??
My idea is :get the sw and ne point, choose every value live inside the rectangle in my database
//zips is my table in the phpmyadmin //$swlat and $swlng are both float format, same format in //$nelat,$nelng $sql = "SELECT ZipCode FROM zips WHERE Latitude BETWEEN '$swlat' AND '$nelat' AND Longtitude BETWEEN '$nelng' AND '$swlng' ORDER BY Population DESC LIMIT 5";