Welcome Guest, Not a member yet? Register   Sign In
display date

i am facing the following problems

* I have designed coupons on the front page with a from date and a to date.
*the coupons table has a from field and a to field. now by default it prints from 0000-00-00 00:00:00 to 0000-00-00 00:00:00
now my problem is if a change the to date in the database and refresh the page the coupon doesnt show.

ill paste the model code here
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.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;


Messages In This Thread
display date - by El Forum - 11-29-2010, 10:42 PM
display date - by El Forum - 11-30-2010, 12:53 AM
display date - by El Forum - 11-30-2010, 01:45 AM

Theme © iAndrew 2016 - Forum software by © MyBB