display $this->db->query();

[eluser]rochellecanale[/eluser]
hey guys i just want to ask how can i display the sql that comes from my $this->db->query?
How can i display the output to the view? Here's my code.

Code:

$sql = "SELECT member_id,username,account_type,completion_date,total
        FROM member
        RIGHT JOIN points_ledger
        ON member.member_id = points_ledger.fkmember";
            
        $data['query'] = $this->db->query($sql);        
        $this->load->view('sites/payout',$data);
        $this->load->view('templates/footer');

how can i view it? Should i use foreach()? or just echo $query? I have no idea please help me. And also i want to fetch the value of total, How can i do it? I want to store it in a variable and use it for comparing.

[eluser]LuckyFella73[/eluser]
It's clearly documented in the user guide:
http://ellislab.com/codeigniter/user-gui...sults.html

[eluser]NikosV[/eluser]
First of all, i think i would be best for you if you re-read user guide (http://ellislab.com/codeigniter/user-gui...sults.html).

In your view you should try something like this:

Code:

<?php
foreach ($query->result_array() as $row){
echo $row['member_id'];
echo $row['username'];
}
?>

[eluser]rochellecanale[/eluser]
i tried that but it displays nothing. Here's my modified code:

Code:

my model
public function payout(){
             $sql = "SELECT member_id,username,account_type,completion_date,total
                    FROM member
                    RIGHT JOIN points_ledger
                    ON member.member_id = points_ledger.fkmember";
             return $this->db->query($sql);        
}

my controller
public function payout_module(){
            $data['query'] = $this->sales_model->payout();        
            $this->load->view('sites/payout',$data);
            $this->load->view('templates/footer');
}

my view
foreach($query->result_array as $row){
                    echo "<tr>";
                        echo "<td>1</td>";
                        echo "<td>{$row['username']}</td>";
                        echo "<td>{$row['account_type']}</td>";
                        echo "<td>{$row['completion_date']}</td>";
                        echo "<td>{$row['total']}</td>";
                    echo "</tr>";
}

[eluser]rochellecanale[/eluser]
Ah ok i found my error in my view i forgot to include the () at the end of result_array thanks for the response guys.

[eluser]NikosV[/eluser]
Always glad to help