New answers tagged

0

I found solution my code is : $query = "SELECT * , (3956 * 2 * ASIN(SQRT( POWER(SIN(( $coorlat - latitude) * pi()/180 / 2), 2) +COS( $coorlat * pi()/180) * COS(latitude * pi()/180) * POWER(SIN(( $coorlng - longitude) * pi()/180 / 2), 2) ))) as distance from places order by distance LIMIT 3"; $db = JFactory::getDBO(); $db->setQuery($query)...


Top 50 recent answers are included