[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');
?>