Welcome Guest, Not a member yet? Register   Sign In
database functions
#1

[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?




Theme © iAndrew 2016 - Forum software by © MyBB