Join statement error in CodeIgniter 2.x

Asked Jul 29 '16 at 11:44

Active Jul 29 '16 at 11:44

Viewed 29 times

I am trying to join 2 tables in a database but i am finding an error which is like

Parse error: syntax error, unexpected '=' in C:\xampp\htdocs\Hostel\application\models\studentaccounts.php on line 37

my model code is as follows

$query=$this->db->select('*')
        ->from('student')   
        ->join('securitybill','securitybill.student_id'='student.student_id','inner')
                 ->get();   
        return $query->result();

I have check out the documentation it states the code similar to it but i am still facing the issue...can you tell me what is the issue with my code?

asked Jul 29 '16 at 11:44

Abhishek Joshi

1

`'securitybill.student_id'='student.student_id'` <-- incorrect – John Conde Jul 29 '16 at 11:45
1

'securitybill.student_id=student.student_id' – Rijin Jul 29 '16 at 11:45
Try like this `'securitybill.student_id = student.student_id'` – Abdulla Nilam Jul 29 '16 at 11:48
Change your join statement from :- 'securitybill.student_id'='student.student_id' to :- 'securitybill.student_id=student.student_id' – Andy Jul 29 '16 at 11:53

Join statement error in CodeIgniter 2.x

0 Answers0