[eluser]Vitsaus[/eluser]
Once again with stupid questions.
I'm running into difficulties with CI's way to produce queries from database. I have a following query and I have no idea how to convert into CI world:
Code:
SELECT pages.id, pages.title, pages.shortly, pages.content, pages.last_edit_time, pages.last_editor, pages.url, customers.first_name, customers.last_name
FROM pages
WHERE pages.id = '$id'
INNER JOIN customers
ON pages.last_editor_id = customers.id
This is what I tried when reading documentation but there is obviously problems with the way I give names to my tables in MySQL database.
Code:
// Notice customers.first_name, customers.last_name in the end of the first line. Something wrong with that naming convention?
$this->db->select('pages.id, pages.title, pages.shortly, pages.content, pages.last_edit_time, pages.last_editor, pages.url, customers.first_name, customers.last_name');
$this->db->from('pages');
$this->db->join('customers','pages.last_editor = customer.id');
$this->db->where('pages',$id);
$db = $this->db->get();
This try just produces following error:
Error Number: 1054
Unknown column 'pages' in 'where clause'
SELECT `pages`.`id`, `pages`.`title`, `pages`.`shortly`, `pages`.`content`, `pages`.`last_edit_time`, `pages`.`last_editor`, `pages`.`url`, `customers`.`first_name`, `customers`.`last_name` FROM (`pages`) JOIN `customers` ON `pages`.`last_editor` = `customer`.`id` WHERE `pages` = 2
So, the resultinq query is obviously not what I want. Is there any clearer documention on using joins and making bit more complicated SQL queries with CI?
Edit, fixed by myself,just some stupid typos etc.