display date - Printable Version

Code:
function getCouponsToFrontpage($count)

    {

        $result = $this->db->query('SELECT coupon_to_frontpage.coupon_id as coupon_id,

                                    coupon_to_frontpage.updated_at as updated_at,

                                    coupons.entry_id,coupons.name,coupons.text,coupons.image_path,

                                    coupons.image_rights,coupons.image_description,coupons.from,

                                    coupons.to , coupons.from, coupons.to, coupons.published,

                                    coupons.canceled, coupons.updated_at as coupon_updated,date_format(coupons.from,"%d.%m.") as formated_date_from,date_format(coupons.to,"%d.%m.%Y") as formated_date_to 

                                    FROM '.$this->table.'

                                    LEFT JOIN coupons  ON  '.$this->table.'.coupon_id = coupons.id

                                    WHERE coupons.published = 1

                                    AND ((date_format(current_date,"%d-%m-%Y") 

                                    BETWEEN date_format(coupons.from,"%d-%m-%Y") 

                                    AND date_format(coupons.to,"%d-%m-%Y")) 

                                    OR date_format(coupons.to,"%d-%m-%Y") = "00-00-0000") 

                                    ORDER BY coupons.from desc 

                                    LIMIT '.$count);

        $result = $result->result_array();

        return $result;

    }

}