codeigniter join query

PHOTO EMBED

Wed Jun 08 2022 10:57:59 GMT+0000 (Coordinated Universal Time)

Saved by @cehabhishek

$this->db->select('*'); // Select field
		$this->db->from('package'); // from Table1
		$this->db->join('pcategory', 'package.pcategory = pcategory.id', 'INNER'); // Join table1 with table2 based on the foreign key
		$data['Package'] = $this->db->get();
		
		$this->load->view('Admin/viewpackage.php', $data);
content_copyCOPY