gistfile1.txt

$list_pattern = 'SELECT 
					%5$s AS zip, 
					%6$s AS name, 
					SQRT( ( 
						( %2$d - %8$s ) * 
						( %2$d - %8$s ) 
					) + ( 
						( %1$d - %7$s ) * 
						( %1$d - %7$s ) 
					) ) AS distance 
					FROM %4$s WHERE 
					%7$s BETWEEN 
						( %1$d - %3$d ) AND 
						( %1$d + %3$d ) 
					AND 
					%8$s BETWEEN 
						( %2$d - %3$d ) AND 
						( %2$d + %3$d ) 
					AND 
					SQRT( ( 
						( %2$d - %8$s ) * 
						( %2$d - %8$s ) 
					) + ( 
						( %1$d - %7$s ) * 
						( %1$d - %7$s ) 
					) ) < %3$d 
					ORDER BY distance ASC';
				
			$list_query = sprintf( 	$list_pattern, 
						$list_coords[0], 
						$list_coords[1], 
						$list_range,
						$this->geo_table, 
						$this->geo_field_zip, 
						$this->geo_field_name, 
						$this->geo_field_lat, 
						$this->geo_field_lon );



converting lat/lang into km - which ends up each as integer in the database!

$ko_lat_g = explode( ".", $lat );
$ko_lat   = round( ( ( ( $ko_lat_g[0] * 60 ) + $ko_lat_g[1] ) * 1.852 ), 0);

$ko_lon_g = explode( '.', $lon );
    $ko_lon   = round(
        ( ( $ko_lon_g[0] * 60 ) + $ko_lon_g[1] ) *
        ( cos( deg2rad( $ko_lon_g[0] + ( $ko_lon_g[1] / 60 ) ) ) * 1.852 )
    , 0 );