[eluser]adamp1[/eluser]
Now I'm trying to create a SQL query using active record. But the SQL query being created is wrong, it escapes the wrong bits.
Code:
$this->db->select("page.*, user.name");
$this->db->from("page");
$this->db->join("user","page.user = user.id");
$query = $this->db->get();
This outputs with the following error:
Code:
Error Number: 1054
Unknown column 'page.*' in 'field list'
SELECT `page`.`*`, `user`.`name` FROM `page` JOIN `user` ON `page`.`user` = `user`.`id`
Now if I run this as a SQL query manually but removed the quotes from around
`page`.`*` so it is just
page.* it works fine.
There wasn't a problem with CI 1.6.3 but as soon as I upgraded to CI 1.7 it breaks.