◆CI里不能使用mysql的ifnull函数吗？◆

sking

$this->db->select("a.id, a.name, (a.count - ifnull(b.baseCount, 0)) as curCount");
$this->db->from("t1 a");
$this->db->join("t2 b", "a.id = b.id", "left outer");
return $this->db->get();

这段加上ifnull就会报错，把ifnull去掉就不会报错，请问如何处理？谢谢!

visvoy

$this->db->select(array("a.id", "a.name", "(a.count - ifnull(b.baseCount, 0)) as curCount"));

sking

$this->db->select(array("a.id", "a.name", "(a.count - ifnull(b.baseCount, 0)) as curCount"));
visvoy 发表于 2010-4-8 00:44

    好，我试试，谢谢先！

被时间思牵

成功了,太感谢楼主了