[eluser]Unknown[/eluser]
I'm have a serious problem with
query() method usage,
trying to do this query:
Code:
$arr['query'] = "SELECT motoboy.*, veiculo.*, avaliacao.*, (((acos(sin(({$lat} * pi()/180))
* sin((motoboy.latitude * pi()/180))+cos(({$lat} * pi()/180)) * cos((motoboy.latitude * pi()/180))
* cos((({$lng} - motoboy.longitude)*pi()/180))))*180/pi())*60*1.1515*1.609344)
AS distance FROM motoboy JOIN veiculo ON veiculo.id_motoboy = motoboy.id
JOIN avaliacao ON avaliacao.id_motoboy = motoboy.id WHERE motoboy.status = '1'
HAVING distance <= {$this->distance} ORDER BY distance"
So, this query has a
join with another 2 tables
"veiculo" and "validacao", and a simply math to
calculate geo location based on latitude, longitude.
This query just ignore join clause and where, but
this works fine into
phpMyAdmin.
Someone can give me some help? :down:
Thanks!