Query method doens't work! - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20) +--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23) +--- Thread: Query method doens't work! (/showthread.php?tid=58827) |
Query method doens't work! - El Forum - 07-24-2013 [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)) 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! Query method doens't work! - El Forum - 07-25-2013 [eluser]SmokeyJoe[/eluser] generally this looks fine to me. Maybe you can try it this way to receive an error if it doesn't work Code: $this->db->select(a.*, b.*, c.*, (((acos(sin(({$lat} * pi()/180)) Query method doens't work! - El Forum - 07-31-2013 [eluser]Unknown[/eluser] Thanks for the help, i'm following your structure and make some changes to works inside my select method Code: $arr['select'] = "motoboy.*, veiculo.*,(((acos(sin(({$lat} * pi()/180)) |