Easy migration from mysql syntax to CI syntax.

[eluser]debow[/eluser]
I'm trying to covert this...

Code:

$sql = "UPDATE eresults set eventrank=NULL and eventscore=NULL";
    $res = sqlQuery($sql);
    return 99;

To this.. but below isn't working.

Code:

$this->db->update('eresults');
$this->db->set('eventrank','NULL');
$this->db->set('eventscore','NULL');
$this->db->where('event','100m');
$return $this->db->affected_rows();

Any suggestions. Thanks