Database

[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;
    }