public function __construct(Lib_Db $db, array $bannerParams) { $where = ''; foreach ($bannerParams as $key => $value) { $where .= $key .'=\'' . $db->escape($value) . '\' AND '; } $select = 'SELECT headers, code, rank, valid_from, valid_until FROM qu_pap_cachedbanners WHERE '.rtrim($where, 'AND ').' AND (valid_until > \''.date(self::DATETIME_FORMAT).'\' OR valid_until IS NULL) AND (valid_from < \''.date(self::DATETIME_FORMAT).'\' or valid_from IS NULL)'; $this->res = $db->query($select); if($this->res){ $this->count = mysql_num_rows($this->res); } }