database error in select with join

[eluser]mardon[/eluser]
Hi all,

Code:

function getAllActive($limit = 0, $offset = 0) {

        $today = date('Y-m-d');
        $this->db->select('certs.*');
        $this->db->select('users.prijmeni as jmeno');
        $this->db->from('certs');
        $this->db->join('users', 'certs.id_user=users.id');
        $this->db->where('konec>= ',$today);
        $this->db->limit($limit,$offset);
        $q = $this->db->get();
        if ($q->num_rows() > 0) {
            foreach ($q->result() as $row) {
                $data[] = $row;
            }
            return $data;
        }
    }

produce :

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2011-05-23' LIMIT 3' at line 4

SELECT `certs`.*, `users`.`prijmeni` as jmeno FROM (`certs`) JOIN `users` ON `certs`.`id_user`=`users`.`id` WHERE `konec>=` '2011-05-23' LIMIT 3

code

Code:

function getAll($limit = 0, $offset = 0) {

        $this->db->select('certs.*');
        $this->db->select('users.prijmeni as jmeno');
        $this->db->from('certs');
        $this->db->join('users', 'certs.id_user=users.id');
        $this->db->limit($limit,$offset);
        $q = $this->db->get();
        if ($q->num_rows() > 0) {
            foreach ($q->result() as $row) {
                $data[] = $row;
            }
            return $data;
        }
    }

is OK, how I write select with the where function?

[eluser]CroNiX[/eluser]
Does adding a space after 'konec' help?
$this->db->where('konec >=',$today);

Also, you might need to use the 3rd parameter which doesn't escape the field.
$this->db->where('konec >= ',$today, FALSE);