drduh44480 2014-12-01 08:22
浏览 50
已采纳

Mysql Query将在日期返回null [关闭]

hello i have this MYSQL QUERY

 public function getInvoices($data,$date1,$date2)
{
    $get = "Select count(*) as count,
              str_to_date(concat(yearweek(date),'monday'),'%X%V %W') as date,
              DATE_ADD(str_to_date(concat(yearweek(date),'monday'),'%X%V %W'),INTERVAL 6 DAY) as endDate
              FROM affilitechargebackResponse
              WHERE companyID = ".$data."
              AND date >=".$date1."
              AND date <=".$date2."
              AND process = 1
              group by yearweek(date);";
   $query = $this->db->query($get);
   return $query->result();
}

I dont know what is the reason why nothing will return even i have a data from my database. When i delete the line AND date <=".$date2." the code will return the data from db..Even i try BETWEEN still it return null

  • 写回答

3条回答 默认 最新

  • douzhi1813 2014-12-01 08:30
    关注

    Try this it will work :

    $get = "Select count(*) as count,
                  str_to_date(concat(yearweek(date),'monday'),'%X%V %W') as date,
                  DATE_ADD(str_to_date(concat(yearweek(date),'monday'),'%X%V %W'),INTERVAL 6 DAY) as endDate
                  FROM affilitechargebackResponse
                  WHERE companyID = ".$data."
                  AND date >='".$date1."'
                  AND date <='".$date2."'
                  AND process = 1
                  group by yearweek(date);";
    

    Remove double quotes from date1 and date2. Use single quotes.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题