duandu8202 2016-06-28 10:40 采纳率: 0%
浏览 54
已采纳

Codeigniter致命错误在布尔值上调用成员函数result()

I have been having a problem with a query which results in the following error

PHP Fatal error:  Call to a member function result() on boolean on line 200

I'v had no problems with other queries, but on this one I have to do a query within a query, which is the following:

$this->load->helper('date');
$datestring = "%Y-%m-%d";
$time = strtotime('yesterday');
$date= mdate($datestring, $time);

$db = $this->load->database('macs', TRUE);

$query = $db->query("SELECT TEMP1.USER AS PACKER, Count(TEMP1.[ORDER]) AS ORDERS FROM (SELECT AUDIT.USER, AUDIT.[ORDER] FROM AUDIT WHERE AUDIT.DATE > '$date' AND (AUDIT.TYPE='I11' Or AUDIT.TYPE =' 11') GROUP BY AUDIT.DATE, AUDIT.TYPE, AUDIT.USER, AUDIT.[ORDER]) AS TEMP1 GROUP BY TEMP1.USER ORDER BY Count(TEMP1.[ORDER]) DESC");

return $query->result();
$macsdb->close();

This works correctly in access (The above is a conversion of an access query). The query starts to work (incorrectly however) when anything referencing USERis removed and even works when USER is replaced with another field such as Company. What could be causing this query to not be working with USER?

  • 写回答

1条回答 默认 最新

  • duan19911992 2016-06-28 11:38
    关注

    I ran the query without putting return and got a syntax error. The problem was anything regarding USER had to become [USER]

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Spark加载本地pipelinemodel报错
  • ¥20 电脑鼠标键盘不好使了
  • ¥15 求糕手!用matlab求解目标规划模型🙏
  • ¥15 画出的分类图不对,求解答一下
  • ¥20 springboot和springcloud版本问题
  • ¥15 ps2手柄控制树莓派小车
  • ¥30 C#:vsto powerpoint的外接程序
  • ¥15 两个同维数组相比,不同位置、出现重复比无意义,而不同位置、不出现重复比,则有意义。把有意义的两个数组放入新的集合MK中。
  • ¥15 写一个可直接调用的函数,将32位有符号数转成另一个无符号的数
  • ¥15 CMAKE+VS2019+QT5.15.2组合进行二次编译