联系官方销售客服
1835022288
028-61286886
插件 | 考试系统 V1.25 |
应用作者 | 迅睿官方团队 |
发布时间 | 2019-06-13 15:03:16 |
更新时间 | 2024-09-10 08:50:50 |
在用户中心,我的答卷列表页,增加了时间段搜索,搜索结果报错
搜索代码:
<div class="margin-bottom-15 margin-top-10">
<form action="{SELF}" method="get">
{dr_form_search_hidden()}
<div style="float:left;margin-right:20px;">
<label>
<div class="input-group date-picker input-daterange" data-date="" data-date-format="yyyy-mm-dd">
<input type="text" class="form-control" value="{$param.date_form}" name="date_form" autocomplete="off">
<span class="input-group-addon"> {dr_lang('到')} </span>
<input type="text" class="form-control" value="{$param.date_to}" name="date_to" autocomplete="off">
</div>
</label>
</div>
<div style="float:left;margin-right:20px;">
<label><button type="submit" class="btn blue btn-sm " name="submit" > <i class="fa fa-search"></i> {dr_lang('搜索')}</button></label>
</div>
</form>
</div>
报错代码:
mysqli_sql_exception #1052
Column 'inputtime' in where clause is ambiguous
SELECT count(*) as total FROM `dr_1_kaoshi_form_son` LEFT JOIN `dr_1_kaoshi` ON `dr_1_kaoshi_form_son`.`cid`=`dr_1_kaoshi`.`id` WHERE `dr_1_kaoshi_form_son`.`uid` = 2 AND `inputtime` BETWEEN 1681660800 AND 1681747199
这个用什么办法怎么处理呢?