php - codeigniter count_all_results 与连接表

Question

这个问题已经有答案了:

PHP parse/syntax errors; and how to solve them (20 个回答)

已关闭 5 年前。

我在从表中获取行数时遇到问题。

这是我使用 codeigniter 进行的 mysql 查询:

$this->db->where('rd', 1);
$this->db->where('id_user_first', $user_type);
$this->db->from("messaging");
$this->db->join('answers', "answers.id_message = messaging.id AND answers.id_user != '$user_type'");
$count_reponse  = $this->db->count_all_results();

我收到此错误消息:

Parse error: syntax error, unexpected '' '' (T_CONSTANT_ENCAPSED_STRING), expecting ',' or ';' in

Answer 1

您可以尝试此解决方案来解决您的问题:

Please changes query

$this->db->select('messaging.*, answers.*');
$this->db->from("messaging");
$this->db->join('answers', "answers.id_message = messaging.id");
$this->db->where('answers.id_user <>', $user_type);
$this->db->where('messaging.rd', 1);
$this->db->where('messaging.id_user_first', $user_type);
$count_reponse  = $this->db->count_all_results();