Welcome Guest, Not a member yet? Register   Sign In
active record for [where date >= now()]
#1

[eluser]RaZoR LeGaCy[/eluser]
How can I set and active record for where date >= now()

I tried including helper date
I tried this
Code:
$this->db->select('title, dvd, date');
$this->db->from('hh_events');
$this->db->limit ('7');
$this->db->like ("(dvd LIKE '1' OR theater LIKE '1')");

$this->db->where ("(date >= now())");

$data['events'] = $this->db->get();

Everything works without the date part but I need the date part for my events system


Messages In This Thread
active record for [where date >= now()] - by El Forum - 08-01-2007, 08:26 PM
active record for [where date >= now()] - by El Forum - 08-01-2007, 08:35 PM
active record for [where date >= now()] - by El Forum - 08-01-2007, 08:38 PM
active record for [where date >= now()] - by El Forum - 08-02-2007, 09:22 AM
active record for [where date >= now()] - by El Forum - 08-02-2007, 05:17 PM
active record for [where date >= now()] - by El Forum - 08-02-2007, 06:18 PM
active record for [where date >= now()] - by El Forum - 08-03-2007, 06:48 AM
active record for [where date >= now()] - by El Forum - 08-04-2007, 12:19 PM
active record for [where date >= now()] - by El Forum - 08-06-2007, 04:12 PM
active record for [where date >= now()] - by El Forum - 08-06-2007, 07:06 PM
active record for [where date >= now()] - by El Forum - 08-06-2007, 07:45 PM
active record for [where date >= now()] - by El Forum - 08-06-2007, 09:52 PM
active record for [where date >= now()] - by El Forum - 09-23-2007, 10:19 AM
active record for [where date >= now()] - by El Forum - 09-23-2007, 08:50 PM
active record for [where date >= now()] - by El Forum - 09-23-2007, 11:01 PM
active record for [where date >= now()] - by El Forum - 09-24-2007, 03:48 AM
active record for [where date >= now()] - by El Forum - 09-28-2007, 12:35 AM



Theme © iAndrew 2016 - Forum software by © MyBB