phpmyadmin 和 Codeigniter 的 $this->db->query() 函数的结果不一致

Question

用户表

id  stamp_created          email_address
1   2013-03-06 22:00:01    [e-mail]
2   2013-03-20 22:00:08    [e-mail]
3   2013-03-27 22:00:17    [e-mail]
4   2013-04-01 22:00:27    [e-mail]

我有这个查询

SELECT
    `user`.*
FROM
    `user`
WHERE
    `user`.`email_address` IS NOT NULL
    AND (`user`.`stamp_created` BETWEEN '2013-04-01 00:00:00' AND '2013-04-01 23:59:59')

在phpmyadmin中运行查询时，我得到了正确的结果

4   2013-04-01 22:00:27    [e-mail]

但是当我通过

运行查询时

$sql = "SELECT
    `user`.*
FROM
    `user`
WHERE
    `user`.`email_address` IS NOT NULL
    AND (`user`.`stamp_created` BETWEEN '2013-04-01 00:00:00' AND '2013-04-01 23:59:59')
";
$this->db->query($sql)->result_array();

我得到一个空数组

知道为什么会这样吗?

注:已经确认CI和phpmyadmin使用相同的数据库，所以这不是问题。

Answer 1

如果你尝试

$query = $this->db->sql('yourquery');
if($query->num_rows() > 0){
   foreach($query->result() as $row){
      $retdat[] = array(
           'test1' => $row->stamp_created
     ); 
  }
    print_r($retdat);
}