CODEWITHSUNDEEP
mysqlcodeignitersearchjoin
Russell
Russell

Reputation: 1814

Codeigniter Data Retrieve

Here is my database structure database

same subject may have many teachers. First database teacher field is foreign with another database. When searching individual subject how to get full teacher details.

Upvotes: 1

Views: 38

Answers (1)

Abdulla Nilam
Abdulla Nilam

Reputation: 38652

Try this

SELECT *
FROM subject
FULL OUTER JOIN teachers
ON subject.teacher = teachers.id
WHERE subject.subject LIKE '$search';

Why FULL OUTER JOIN??

01

How in CI?

$query = $this->db->query("SELECT * FROM subject FULL OUTER JOIN teachers ON subject.teacher = teachers.id WHERE subject.subject LIKE '$search' ");
$result = $query->result_array();
return $result;

Upvotes: 3

Related Questions