php - 在 Codeigniter 模型中排序

Question

    $query = ('SELECT tb_imam.*, tb_bidang.bidang
                 FROM tb_imam JOIN tb_bidang
                   ON tb_imam.bidang_id = tb_bidang.id
                WHERE tb_imam.status = "Pengerja"
            ');

    return $this->db->query($query)->result_array();

如何使用这样的代码添加订单？求你的帮助，谢谢

标签： phpcodeigniter

Answer 1

只需使用ORDER BY

$query = "SELECT tb_imam.*, tb_bidang.bidang
         FROM tb_imam 
         JOIN tb_bidang ON tb_imam.bidang_id = tb_bidang.id
         WHERE tb_imam.status = 'Pengerja' 
         ORDER BY prefix.column_name";

return $this->db->query($query)->result_array();

JOIN!==LEFT JOIN

习惯Query Builder Class。