[eluser]shinokada[/eluser]
I want to convert the following to active record.
How can I do it?
Code:
$query = $this->db->query("SELECT DATE_FORMAT(eventDate,'%d')
AS day,eventContent,eventTitle,id,user,user_id
FROM eventcal
WHERE eventDate
BETWEEN '$current_year/$current_month/01'
AND '$current_year/$current_month/$total_days_of_current_month'");
Can I use BETWEEN in the active record?