Welcome Guest, Not a member yet? Register   Sign In
Using get_where to get data between today and last x days from database
#1

(This post was last modified: 01-07-2019, 12:50 PM by castle.)

This is working:

PHP Code:
$this->db->select('*');
$this->db->where('payment_timestamp BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()');
$this->db->where('vendor'$id);
$data['dash_sale_d'] = $this->db->get('sale'); 


This is not:

PHP Code:
$data['dash_sale_d'] = $this->db->get_where('sale', array('vendor' => $id'payment_timestamp' => 'BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW()')); 


What am I missing?
Reply


Messages In This Thread
Using get_where to get data between today and last x days from database - by castle - 01-07-2019, 12:49 PM



Theme © iAndrew 2016 - Forum software by © MyBB