KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to join two tables and display there data in single table. I looked at the user guide that codeigniter has and I am not sure how this works. $this->db->join(); What table should be first and what id key should be first. Can someone explain me more in detail about this please use examples if you can. I am trying to join credential table and tblanswers. I have tried to code a function using this example: $this->db->select('*'); $this->db->from('blogs'); $this->db->join('comments', 'comments.id = blogs.id'); $query = $this->db->get(); EDIT: Instead of using join method in CodeIgniter is it possible to use a simple function to retrieve the two table data separately? All I want is to echo the data from database table on to a html table in my website page to be displayed is it possible to write two get functions to retrieve two tables separately?
Tags (comma-separated)
Save Edits
Cancel