在两个日期之间过滤MYSQL [英] Filter between two dates MYSQL

问题描述

我有一个激励表:

inc_id  int(11)          
inc_date    date    
inc_projectname     varchar(256)         
inc_amount  varchar(256)         
inc_developer_id    int(11)      
inc_sales_id    int(11)  
inc_developer_amt   varchar(256)    
inc_sales_amt   varchar(256)

我正在尝试编写一个sql查询以在两个日期之间获取特定用户的条目.这样做的功能是:

I am trying to write a sql query to fetch entry of a specific user between two date.The function to do so is:

 public function  get_all_incentive_by_id ($userid,$inc_from,$inc_to) {  

        //$result = DB::fetch('select * from incentive_table ORDER BY inc_date ASC;');

        $result = DB::fetch("select * from incentive_table where inc_date > '$inc_from' AND inc_date < '$inc_from' ORDER BY inc_date ASC");


        return $result;
        } 

错误:没有输出.

必填项:我希望从一个用户ID获得两个日期之间的结果

Required: I want result between two dates from a user id

推荐答案

$result = DB::fetch("SELECT * FROM incentive_table WHERE inc_date BETWEEN '$inc_from' AND '$inc_to' AND inc_sales_id ='$userid'" ORDER BY inc_date ASC");

这篇关于在两个日期之间过滤MYSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！