Codeigniter Query doesn't return result value [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed last year.

Improve this question

I got the following snippet to get some userrights out of the db:

    $tmp   = "SELECT REPLACE(group_concat(CAST(".$role." AS CHAR)),',','') AS rights FROM functionrights ORDER BY id ASC";
    $query = $this->CI->db->query($tmp);
    if($query->num_rows()>0){
        $row = $query->row(); 
        return $row->rights;

This returns nothing. If I execute the statement direct everything is ok?! What is wrong here?

try to use: return $query->result();and then you can manipulate the result — Christian Giupponi
– Christian Giupponi, Commented Jan 22, 2013 at 14:38
This returns: Array ( [0] => stdClass Object ( [rights] => ) ) — fillibuster
– fillibuster, Commented Jan 22, 2013 at 14:43
Examine your raw SQL. Try: print $this->CI->db->last_query; perhaps you have an error in your SQL — m4t1t0
– m4t1t0, Commented Jan 22, 2013 at 15:00
As I mentioned above - if I execute the raw statement via Navicat or Netbeans (SELECT REPLACE(group_concat(CAST(role1 AS CHAR)),',','') AS rights FROM functionrights ORDER BY id ASC) everthing is ok. — fillibuster
– fillibuster, Commented Jan 22, 2013 at 15:16

m4t1t0 · Accepted Answer · 2013-01-22 14:58:50Z

1

Change $this->CI->db->query to $this->db->query

The ->CI is not necessary. Also, you have no } tag (but that could be just a copy/paste thing).

Besides that: ->row() returns one result, while ->result() returns all results.

edited Jan 22, 2013 at 14:58

m4t1t0

5,7313 gold badges25 silver badges30 bronze badges

answered Jan 22, 2013 at 14:40

Luc

3413 silver badges8 bronze badges

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

2 Comments

fillibuster Over a year ago

Hey, it's a snippet ;-). I use $this->CI because it is a library.

fillibuster Over a year ago

Please delete this - wrong database where the table values are empty - damn!

Collectives™ on Stack Overflow

Codeigniter Query doesn't return result value [closed]

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related