db->query HELP :(

[eluser]Linderman[/eluser]
I have this:

Code:

$query = "INSERT INTO ci_images (id, imagetype, usage, usage_id, size_num, size, name, fullpath, comment) VALUES ('', '$data[imagetype]', '$data[usage]', '$data[usage_id]', '$data[size_num]', '$data[size]', '$data[name]', '$data[fullpath]', '$data[comment]')";

$r = $this->db->query($query);

when executed i got:

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 'usage, usage_id, size_num, size, name, fullpath, comment) VALUES('', 'o' at line 1

I am sure that $data array contain all the needed elements. I even tested with hard coded values ... but this error continuing to appear???

When i use

Code:

$this->db->insert('ci_images', $data);

- everything is OK , but , please explain me , why

Code:

$this->db->query($query);

does not work???