CodeIgniter Forums
How to output SQL query? [SOLVED] - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to output SQL query? [SOLVED] (/showthread.php?tid=10546)



How to output SQL query? [SOLVED] - El Forum - 08-04-2008

[eluser]Frychiko[/eluser]
Hi,

How can I output a SQL query to the screen?

When I have errors in my query I like to output it on screen and paste it into phpmyadmin to debug.

cheers!

EDIT: Stupid me, it was in the documentation:

echo $this->db->last_query();


How to output SQL query? [SOLVED] - El Forum - 08-04-2008

[eluser]johnwbaxter[/eluser]
http://ellislab.com/codeigniter/user-guide/general/profiling.html

This may also be of a lot of use.