SQL calulcation done in php

Hi

I have an sql query that calculates distance out of few columns. How could I do the same calulcation in php using variables?

Thanks.

This is the query:

$query = sprintf("SELECT address, name, lat, lng, ( 6371 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < '%s' ORDER BY distance LIMIT 0 , 20",

Code (markup):

This is the calculation:

( 6371 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) )

Code (markup):

 

http://www.zipcodeworld.com/samples/distance.php.html

Usefull?

 

Thank you!

Now it works!