+- 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: Database (/showthread.php?tid=3306)
Database - El Forum - 09-23-2007
[eluser]imzyos[/eluser]
mmm... code
Code:
$this->db->select('title')->from('mytable')->where('id', $id)->limit(10, 20);
echo $this->db->querystring();The echo $this->db->querystring(); must show something like this "select title from my table where id = $id limit 10,20" needed to debug our querys, some function with this behaviour?
may be...
Code:
function getquerystring($table = '', $limit = null, $offset = null)
{
if ($table != '')
{
$this->from($table);
}
if ( ! is_null($limit))
{
$this->limit($limit, $offset);
}
$sql = $this->_compile_select();
return $sql;
}