foreach

can you show some code you’re using? You get any errors? how does it fail to process template tags?

OK, I did some other checking around–it fails because my results array is empty. Tested a few queries I selected at random, like: $this->EE->db->query(“SELECT message_id FROM exp_message_data”);

And they always return something like:

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #38
    [result_id] => Resource id #83
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 37
    [row_data] => 
)

I have another query running the page that returns data from exp_members just fine.

What’s your code to generate that?

Look at the CI docs on the database class: http://ellislab.com/codeigniter/user-guide/database/active_record.html

you need something like:

$query = $this->EE->db->select('foo')->get('bar');

if ($query->num_rows() !== 0) 
{
   foreach ($query->result() as $row) 
   {
      var_dump($row);

      // or
      echo $row->foo; // for the var you're trying to get
   }
}

I hope that makes sense. The CI docs should help.

-greg

Thank you!

Same result with a chained method as outlined in the CI documentation.

I printed out the CI_DB_mysql_driver Object and the query was valid. However, the result array returned empty–but the number of records was correct.

Here is one thing I’ve tried when retrieving number of new PM’s:

<?php 
echo "<pre>";
$this->EE->db->select('private_messages')->where('member_id', $this->EE->session->userdata['member_id']);
$new_messages = $this->EE->db->get('exp_members');
print_r($new_messages);
echo "</pre>

<p>”;
?>

Which gives

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #38
    [result_id] => Resource id #66
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 1
    [row_data] => 
)

But, now this works:

$mquery = $this->EE->db->query("SELECT private_messages FROM exp_members WHERE member_id = '".$this->EE->session->userdata['member_id']."'"); 
echo "<pre>";
print_r($mquery);
echo "</pre>

<p>”;

However, any query run after that in the query() method returns proper number of rows, but does not return result array or object.

Actually, it appears that given the way shown in my last post, most other queries fail to return a result array.

Anyone?