[eluser]gregmax17[/eluser]
I have trouble with this query using active record:
Code:
return $this->db->get_where('games', array('datetime <=' => 'NOW()', 'status' => 'tba'))->result();
which generates this query:
Code:
select * from `games` where `datetime` <= 'NOW()' and `status`='tba'
notice how it puts single quotes around 'NOW()'? How do I tell active record to use this as a mysql function instead of a string?