Working with CURRENT_TIMESTAMP

[eluser]codemonkey[/eluser]
Holy smokes, I think I'm getting somewhere. If i do

Code:

function get_actions_oneweek()
{
$this->output->enable_profiler(TRUE);

$startDate = date("Y-m-d", mktime(0, 0, 0, date('m'), date('d') - 14, date('Y')));
$endDate = date("Y-m-d", mktime(0, 0, 0, date('m'), date('d') - 1, date('Y')));  

$total_actionsweek = 0;
$this->db->select('id');
$this->db->select('COUNT(id) AS total');
$this->db->where('date_created >', $endDate);
$actionweekrows = $this->db->get('item_history')->result_array();

foreach ($actionweekrows as $count => $actionweekrow)
{
$total_actionsweek = ($total_actionsweek + $actionweekrow['total']);
}

return $total_actionsweek;
}

It returns the correct number!!!!

If I can get the between to work this will be amazing!