help with query

[eluser]dadamssg[/eluser]
how do i get his to work.

I copied and pasted my query from my non-codeigniter page to try to use in codeigniter but its thinking that Surrounding is a column in my db but it isn't.

i don't know what to put around Surrounding to tell codeigniter that i want to pull up all events which are not Surrounding.

This should be pretty simple, just don't know the proper syntax...

Code:

<?php
$data['query'] = $this->db->query('SELECT * FROM test WHERE end >= NOW() AND event != 'Surrounding' ORDER BY start ASC');
?>