Getting error in Codeigniter: A Database Error Occurred.The query you submitted is not valid

Question

Below is my model code, in which I'm getting a database error:

public function getxyz()
{
    $query ='SELECT DISTINCT(LEFT(field1,LOCATE('-',field1) - 1)) as field1
    FROM table1';
    $res = $this->db->query($query);
    return $res->result();
}

Note: This query is running successfully in phpmyadmin. Any help will be appreciated. Thanks in advance.

spaniard · Accepted Answer · 2016-03-09 07:42:49Z

3

I think you have an error in the query related to the single quotes you are using to enclose the query. They are interfering with the single quotes to the string - seems out of the query. Try this query:

 $query ="SELECT DISTINCT(LEFT(field1,LOCATE('-',field1) - 1)) as field1
        FROM table1";

answered Mar 9, 2016 at 7:42

spaniard

5603 silver badges14 bronze badges

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

Comments

devpro · Accepted Answer · 2016-03-09 07:45:08Z

0

Your query is working fine PHPMYADMIIN because there is no issue with quotes around SQL statement.

You just need to fix single and double quote issue in your query.

Example:

public function getxyz()
{
    $query ="SELECT DISTINCT(LEFT(field1,LOCATE('-',field1) - 1)) as field1
    FROM table1";
    $res = $this->db->query($query);
    return $res->result();
}

answered Mar 9, 2016 at 7:45

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Collectives™ on Stack Overflow

Getting error in Codeigniter: A Database Error Occurred.The query you submitted is not valid

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related