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

[eluser]RaZoR LeGaCy[/eluser]
Okay I'll explain better

This query is needed of the section in http://www.hellhorror.com where it says "Upcoming Horror Movies" in the upper right hand side.

So I had in my hand written code and it worked

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);

But

I can't use that code in CI for some reason

MY DB structure Dump

Code:

--
-- Table structure for table `hh_events`
--

CREATE TABLE `hh_events` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(128) collate utf8_unicode_ci NOT NULL default '',
  `text` text collate utf8_unicode_ci NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `dvd` enum('1','0') collate utf8_unicode_ci NOT NULL default '0',
  `theater` enum('1','0') collate utf8_unicode_ci NOT NULL default '0',
  `game` enum('1','0') collate utf8_unicode_ci NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='release_dates' AUTO_INCREMENT=62 ;

--

Please someone try to replicate and see what may be a hack of some sort

Thanks ALL