Syntax Error SQL Codeigniter

Question

I have this in my code and im using codeigniter yet it's producing an error

        // make call to db and create a file
        $this->db->select("*");
        $this->db->from("mst_global_settings mgs");
        $this->db->join("trans_global_settings tgs", "mgs.global_name_id=tgs.global_name_id", "inner");
        $this->db->where('`tgs`.lang_id', $lang_id);
        $query = $this->db->get();
        $result = $query->result_array();
        $tmp_array = array();
        foreach ($result as $global_array) {
            $tmp_array[$global_array["name"]] = $global_array["value"];
        }

Codeigniter is giving me the following error

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tgs`.`lang_id` = 'en'' at line 4

SELECT * FROM (`p931_mst_global_settings` mgs) INNER JOIN `p931_trans_global_settings` tgs ON `mgs`.`global_name_id`=`tgs`.`global_name_id` WHERE `p931_`tgs`.`lang_id` = 'en'

Filename: /models/mdl_common.php

Line Number: 26

Try removing backticks.

mim.
– mim.

2015-06-16 13:10:14 +00:00
Commented Jun 16, 2015 at 13:10 — mim.
– mim., Commented Jun 16, 2015 at 13:10

CodeGodie · Accepted Answer · 2015-06-16 13:20:03Z

2

The problem is your single quotes.

Change this:

$this->db->where('`tgs`.lang_id', $lang_id);

To this:

$this->db->where('tgs.lang_id', $lang_id);

answered Jun 16, 2015 at 13:20

CodeGodie

12.2k6 gold badges40 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error SQL Codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related