tp5.1搜索会员生日语句怎么写？

[MrXiaoSanYe]

sql语句这样：

select * from member_basic where DATE_FORMAT(borthday,'%m-%d') between '01-01' and '01-20';

tp5.1我是这样写的：

$birthday = explode('至', $birthday);
$startime   = $birthday[0];
$endtime    = $birthday[1];
$where[] = [DATE_FORMAT('borthday','%m-%d'), 'between time', [$startime, $endtime]];
$this->assign('birthday', $birthday);

db('member')
    ->alias("a")
    ->join('member_basic af','a.userid = af.userid')
    ->field("*")
    ->where($where)
    ->order(array('a.userid' => 'desc'))
    ->paginate($limit);

我这样写不行，报错，大神帮指点一下

[xuzuning]

残次品 见 http://www.thinkphp.cn/topic/59687.html