Return to Answer

added 112 characters in body

Source Link

edited Dec 5, 2012 at 16:00

You put WHERE twiceWHERE twice. You can use From_UNIXTIMEFrom_UNIXTIME function in mysql

WHERE FROM_UNIXTIME(renew_date)<NOW() 
    AND FROM_UNIXTIME(renew_date)> (NOW()-INTERVAL 1 year)
    AND renew_date !=''

You put WHERE twice. You can use From_UNIXTIME function in mysql

WHERE FROM_UNIXTIME(renew_date)<NOW() 
    AND FROM_UNIXTIME(renew_date)> (NOW()-INTERVAL 1 year)
    AND renew_date !=''

You put WHERE twice. You can use From_UNIXTIME function in mysql

WHERE FROM_UNIXTIME(renew_date)<NOW() 
    AND FROM_UNIXTIME(renew_date)> (NOW()-INTERVAL 1 year)
    AND renew_date !=''

Source Link

answered Dec 5, 2012 at 15:54

You put WHERE twice. You can use From_UNIXTIME function in mysql

WHERE FROM_UNIXTIME(renew_date)<NOW() 
    AND FROM_UNIXTIME(renew_date)> (NOW()-INTERVAL 1 year)
    AND renew_date !=''