Как написать кодигентер, где () с "colun_name между Now () - интервал 30 дней и теперь ()" ⇐ Php

[Anonymous]

это оба запроса одинаково: < /p>

Код: Выделить всё

SELECT count(site_key) as count_lic
FROM (`activation`)
WHERE `site_key` = '36LYRAHK0100000000B6101442Cs' AND `user_id` = '' AND `request_time` = 'BETWEEN NOW() - INTERVAL 30 DAY AND NOW()
< /code>
и < /p>
SELECT count(site_key) as count_lic
FROM (`activation`)
WHERE `site_key` = '36LYRAHK0100000000B6101442Cs' AND `user_id` = '' AND `request_time` BETWEEN NOW() - INTERVAL 30 DAY AND NOW()

Можем ли мы использовать 'request_time' = 'между .......' ?

Код: Выделить всё

function fGetUsedLicenses($site_id) {

//count number of activations without user_id
$this->db->select('count(site_key) as count_lic');
$this->db->where('site_key', $site_id);
$this->db->where('user_id','');
$this->db->where('request_time', 'BETWEEN NOW() - INTERVAL 30 DAY AND NOW()');
$this->db->from('activation');
$query = $this->db->get();
$result = $query->row();
$count = $result->count_lic;

echo $this->db->last_query();
//count number of activations with unique user_id
$this->db->select('count(DISTINCT user_id) as count_lic');
$this->db->where('site_key', $site_id);
$this->db->where('user_id !=','');
$this->db->where('request_time', 'BETWEEN NOW() - INTERVAL 30 DAY AND NOW()');
$this->db->from('activation');
$query = $this->db->get();
$result = $query->row();
$count += $result->count_lic;

var_dump($count);
echo $this->db->last_query();
exit(0);
return $count;
}

Теперь, если я использую таким образом, сгенерированный запрос - «request_time '» между .....'

Подробнее здесь: https://stackoverflow.com/questions/369 ... nterval-30