How to use variable in a WHERE statement

Hi,

I have in a table a column Latitide and a column Longitude. These are coordinates from a store.
With geolocation I got the coordinates (Latitude and Longitude) from a user of my website.
With a formula I can calculate the distance between the coordinates.

I have the distance inside the WHILE loop.

What I want is to select only the records where the distance is less then 10km.

But how? So far I know I cannot use a variable in the WHERE statement and before I can select records with...

How to use variable in a WHERE statement

from MySQL https://ift.tt/2VU07An
via IFTTT