Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2015
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. //======================================================================//
  2. // Obtengo datos de las rutas AND (usuarios.idfacebook IN ((".implode(',',$friend_ids_arr).") OR recorridos.compartida=2)
  3. //======================================================================//
  4. $sql= "SELECT recorridos.*,recorridos.nombre as nombreRecorrido, recorridos.latitud as Latitud, recorridos.longitud as Longitud, usuarios.*, usuarios.nombre as nombreUsuario,
  5. ( 6371 * acos( cos( radians('$lat') ) *
  6. cos( radians( Latitud ) ) *
  7. cos( radians( Longitud ) -
  8. radians('$lon') ) +
  9. sin( radians('$lat') ) *
  10. sin( radians( Latitud ) ) ) )
  11. AS distance FROM recorridos, usuarios WHERE recorridos.usuarios_idusuarios=usuarios.idusuarios AND ((usuarios.idfacebook IN (".implode(',', $friend_ids_arr).") AND recorridos.compartida=1) OR recorridos.compartida=2)
  12. AND ( 3959 * acos( cos( radians('$lat') ) *
  13. cos( radians( Latitud ) ) *
  14. cos( radians( Longitud ) -
  15. radians('$lon') ) +
  16. sin( radians('$lat') ) *
  17. sin( radians( Latitud ) ) ) ) <= :radio ORDER BY distance ASC LIMIT 0, 10" ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement