Database driver error |
Your query absolutely right. i don't know why it is not working.please use below query as a alternative.
$row1 = $this->db->query("SELECT COUNT(*) AS `numrows` FROM `lids` WHERE `lids`.`date_inspection` >= '2016-10-14 00:00:00' AND `lids`.`date_inspection` <= '2016-10-15 23:59:59'")->row(); $row2 = $this->db->query("SELECT COUNT(*) AS `numrows` FROM `lids` WHERE `date_inspection` >= '2016-10-14 00:00:00' AND `date_inspection` <= '2016-10-15 23:59:59'")->row(); $row3 = $this->db->query("SELECT COUNT(*) AS numrows FROM lids WHERE date_inspection BETWEEN '2016-10-14 00:00:00' and '2016-10-15 23:59:59'")->row(); print_r($row1->numrows); print_r($row2->numrows); print_r($row3->numrows); Above three query is may helpful. |
Messages In This Thread |
Database driver error - by mahlenko - 08-08-2018, 01:52 AM
RE: Database driver error - by mahlenko - 08-08-2018, 05:22 AM
RE: Database driver error - by excellentwebworld - 08-10-2018, 04:46 AM
|