Dear all,

does anybody have a hint for me how I can display the SQL statement (like echo query;) to verify how the query looks like during the run time?

Example:

    $this->src("sales")->query("
        SELECT month,sum(sale)
        FROM tbl_sales
        WHERE month IN (:month)
        GROUP BY sale
    ")->pipe($this->dataStore('month-of-year'));
}

I tried following things but without success: echo query; echo query(); echo $this->src("sales")->query ...

Any hint?

Thx a lot! It woks fine!

Hi support team,

How if i want to store particular SQL statement into session since i run echo ($query) will result multiple SQL statements? Currently i am using Codeigniter. Thanks.