mysql - 我如何从 codeigniter 上的表中获取 id？

Question

我有一个查询，我在 phpmyadmin 上尝试了它，它可以工作。

SELECT  * FROM `penyakit` LEFT JOIN puskesmas ON penyakit.id_puskesmas=puskesmas.id_puskesmas WHERE (YEAR(waktu_upload) = 2018 AND MONTH(waktu_upload) = 12)  AND penyakit.id_puskesmas = 19  

我将此查询用于我的过滤器功能，如下所示：

function status_data($year,$month){
    $this->db->select('*');
    $this->db->from('puskesmas');
    $this->db->group_by('puskesmas.nama_puskesmas');
    $this->db->join('penyakit', 'puskesmas.id_puskesmas=penyakit.id_puskesmas', 'left');

    $data= $this->db->get()->result();

    foreach ($data as $value) {

        $query = $this->db->query("SELECT * FROM `penyakit` LEFT JOIN puskesmas ON penyakit.id_puskesmas=puskesmas.id_puskesmas WHERE YEAR(waktu_upload) = '$year' AND MONTH(waktu_upload) = '$month' 
            AND puseksmas.id_puskesmas=".$value->id_puskesmas);

        $num = $query->num_rows();

         $value->num = $num;
        if($num < 19 ){
            $value->status = "<button type='button' class='btn btn-danger btn-rounded'> Uncomplete</button>";
        }else{
            $value->status = "<button type='button' class='btn btn-success btn-rounded'> Complete </button>";
        }

    }
    //die(print_r($data));
    return $data;
}

但是这个查询不能得到 id 并显示这样的错误。

SELECT * FROM penyakitLEFT JOIN puskesmas ON penyakit.id_puskesmas=puskesmas.id_puskesmas WHERE YEAR(waktu_upload) = '2018' AND MONTH(waktu_upload) = '12' AND puseksmas.id_puskesmas=

未显示此 ID。我该如何解决这个问题？

标签： mysql