gistfile1.php

// age range of registrations
public function age_range($start_date, $end_date, $from_age = 0, $to_age = 50, $language = 'english')
{
    $start_date = date('Y-m-d', $start_date) . ' 00:00:00';
    $end_date = date('Y-m-d ', $end_date) . ' 23:59:59';

    if($to_age == FALSE)
    {
        $sql = 'SELECT COUNT(id) as cnt from users WHERE (created_at BETWEEN ? AND ?) AND timestampdiff(YEAR,birth_date,now()) >= ? AND language = ?';

        $query = $this->db->query($sql, array($start_date, $end_date, $from_age, $language));
    } else {
        $sql = 'SELECT COUNT(id) as cnt from users WHERE (created_at BETWEEN ? AND ?) AND (timestampdiff(YEAR,birth_date,now()) BETWEEN ? AND ?) AND language = ?';

        $query = $this->db->query($sql, array($start_date, $end_date, $from_age, $to_age, $language));
    }

    $total = $query->row()->cnt;
    $query->free_result();
    return $total;
}