This statement works:
$query = "
SELECT COUNT(*)
FROM " . $this->s_createtableName . "
WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW()))
AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)";
In trying to chain the query, this code fails on the WHERE
statement.
$query->select('COUNT(*)');
$query->from('. $this->s_createtableName .');
$query->where("tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)");
Any help would be appreciated.