Issue with special characters and Ajax database updates

[eluser]jsuissa[/eluser]
Think I found my answer:

BEFORE:

Code:

$sql = "UPDATE $table SET $field = $value WHERE $whereField =  $whereValue";
$query =  $this->db->query($sql);

AFTER:

Code:

$sql = "UPDATE $table SET $field = ? WHERE $whereField =  $whereValue";
$query =  $this->db->query($sql, array($value));

Just by using the ? operator for the value I wanted to change did the trick.