active record for [where date >= now()]

[eluser]Scott - Beyond Coding[/eluser]
[quote author="RaZoR LeGaCy" date="1186269580"]

Code:

mysql_select_db($database_HH, $HH);
$query_events = "SELECT * FROM hh_events WHERE  dvd = 1 AND `date` >= NOW() OR theater = 1 AND `date` >= NOW() ORDER BY `date` ASC LIMIT 0,6";
$events = mysql_query($query_events, $HH) or die(mysql_error());
$totalRows_events = mysql_num_rows($events);

[/quote]

If you just want to rewrite that manual SQL for AR, I'd try something along the lines of:

Code:

$this->db->select();
$this->db->from('hh_events');
$this->db->where('(dvd = 1 AND date >= NOW()) OR (theater = 1 AND date >= NOW())');
$this->db->limit('6');
$this->db->order_by('date ASC');

Haven't tested the code obviously but should be something along those lines..