mysql - 'Array' 中的未知列 'where clause' - 数据库错误

Question

public function count_category_images($p_id)
{
$this->db->select('gallery.*','category.category_name');
$this->db->join('category', 'category.id = gallery.category_id');
$this->db->order_by('gallery.id','desc');
$this->db->where('category.id',$p_id); 

return $this->db->count_all_results('gallery');//line no 81
}

收到此错误

Error Number: 1054 Unknown column 'Array' in 'where clause'

SELECT
    COUNT(*) AS `numrows`
FROM
    `gallery`
JOIN `category` ON `category`.`id` = `gallery`.`category_id`
WHERE
    `category`.`id` = `Array`
ORDER BY
    `gallery`.`id` DESC

文件名:C:/wamp64/www/rox/application/models/roxmodel.php

行号:81

Answer 1

我猜你的$p_id是一个数组。在传递$p_id之前，只需回显并测试$p_id的值

在你的where子句中，你的category.id应该等于某个值而不是数组。