CI执行原生SQL
2024-11-24 18:43:10
//my_helper.php
function dr_discuss_info($uid) {
$ci = &get_instance();
$sql = "select imt_1_mall.*,imt_member_paylog.* from imt_1_mall,imt_member_paylog where imt_member_paylog.discuss_status=0 and imt_member_paylog.uid=$uid and imt_1_mall.id = imt_member_paylog.order_id";
$data= $ci->db->query($sql);
$data = $data->result_array();
return $data;
}