call the ' id ' of the mysql database with varchar format but Unknown column 'GE' in 'where clause'

Question

I tried to call up data by 'id' format id example id = GE-DIS-001 to JOIN table with Codeigniter , the result of "Unknown column ' GE ' in 'where clause ' what's wrong ??

Controller :

    public function detail(){

    $id = $this->uri->segment(4);
    $detail = $this->mcrud->get_detail($id); 

    $data = array(
                'detail'=>$detail,
                'lihat' =>$this->mcrud->lihat_komentar($id),
                'isi'       =>'instrument/read_views');
    $this->load->view('layout/wrapper', $data);


   }

Model :

    public function get_detail($id){

    $sql = "SELECT * FROM tbdetail 
            JOIN tbkalibrasi ON tbkalibrasi.id = tbdetail.id
            JOIN tbsupplier ON tbsupplier.namasupplier = tbdetail.namasupplier

            WHERE tbdetail.id = {$id}
            ";
    return $this->db->query($sql)->result_array();
    }

try to print your query and result you will get what is wrong.... try `print_r($sql); and print_r($this->db->query($sql)->result_array()); ` — Linus, Aug 25 '15 at 03:50
@irwanDwiyanto above thing i mentioned is does not solve your problem but to find what where mistake will be.print the result and post them — Linus, Aug 25 '15 at 04:54
@AnmolRaghuvanshi , This question has been fixed , I tried adding quotes on WHERE tbdetail.id = '".$id."'"; finally running — irwan Dwiyanto, Aug 25 '15 at 06:37

score 1 · Accepted Answer · answered Aug 25 '15 at 03:52

1

It seems $id variable contains string with spaces, so you are getting this error. Change it to

public function get_detail($id){

    $sql = "SELECT * FROM tbdetail 
            JOIN tbkalibrasi ON tbkalibrasi.id = tbdetail.id
            JOIN tbsupplier ON tbsupplier.namasupplier = tbdetail.namasupplier

            WHERE tbdetail.id = '$id'
            ";
    return $this->db->query($sql)->result_array();
    }

answered Aug 25 '15 at 03:52

Harshit

5,147
9
46
93

@irwanDwiyanto, try to put single quotes over the `$id` variable in the query & check if it works. – Harshit Aug 25 '15 at 04:13
have been tried . but it still does not work , I call id ( GE - DIS - 001 ) but MySQL does not read GE – irwan Dwiyanto Aug 25 '15 at 04:28

score 0 · Answer 2 · answered Aug 25 '15 at 03:52

Is your variable for id missing single quotes?

public function get_detail($id){

$sql = "SELECT * FROM tbdetail 
        JOIN tbkalibrasi ON tbkalibrasi.id = tbdetail.id
        JOIN tbsupplier ON tbsupplier.namasupplier = tbdetail.namasupplier

        WHERE tbdetail.id = '{$id}'
        ";
return $this->db->query($sql)->result_array();
}

call the ' id ' of the mysql database with varchar format but Unknown column 'GE' in 'where clause'

2 Answers2