zipcoderadiusQuery.sql

SELECT
	zipcode
	(
		3959 * acos(
			cos(radians($LattitudeVar)) * cos(radians(latitude)) * cos(
				radians(longitude) - radians($longitudeVar)
			) + sin(radians($LattitudeVar)) * sin(radians(latitude))
		)
	) AS distance
FROM
	zipcodedata
HAVING
	distance <= 5
ORDER BY
	distance