mysql的会员表里有个会员出生日期的字段,需要在管理后台里筛选出近十天过生日的会员,字段设的是datetime的,年月日和时间都在一起,一开始一直在想怎么才能只把月日分出来处理呢,研究半天,只能做到同一个月里,十天内过生日的会员,跨不了月。求助吧,一边在论坛上问,一边google着,终于解决了,方法如下:
$d = date('z',time());
$sql="select id from huiyuan where (DAYOFYEAR(date_format(birth,'%Y-%m-%d')) - $d ) < 10 and (DAYOFYEAR(date_format(birth,'%Y-%m-%d')) - $d ) >= 0 order by id desc";
$d = date('z',time());
$sql="select id from huiyuan where (DAYOFYEAR(date_format(birth,'%Y-%m-%d')) - $d ) < 10 and (DAYOFYEAR(date_format(birth,'%Y-%m-%d')) - $d ) >= 0 order by id desc";