Codeigniter不等于查询错误 [英] codeigniter not equal query error
本文介绍了Codeigniter不等于查询错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我怎么能不等于在MySQL数据库中查询到codeigniter框架.我的查询显示不等于admin的位置.这是我的查询
How can i do not equal in my query in mysql database to codeigniter framework. My query shows not equal to the position of admin. Here is my query
$query = $this->db->query('SELECT tbl_user_type.position, tbl_users.user_id, tbl_users.user_fname, tbl_users.user_lname,
tbl_users.user_mname FROM tbl_users INNER JOIN tbl_user_type ON tbl_users.user_type = tbl_user_type.user_type
WHERE !(tbl_user_type.position = Admin) ');
return $query->result();
推荐答案
请使用活动记录查询来执行此任务,使用codeigniter中的活动记录会更加简单.
Please use active records query to do this task, it will be more simple with active records in codeigniter.
$this->db->select("UT.position, U.user_id, U.user_fname, U.user_lname, U.user_mname");
$this->db->from("tbl_users AS U");
$this->db->join("tbl_user_type AS UT", "U.user_type = UT.user_type");
$this->db->where("UT.position !=", "Admin");
$query = $this->db->get();
return $query->result();
用上面的代码替换您的查询.它将解决您的问题.
Replace your query with above code. It will solve your problem.
这篇关于Codeigniter不等于查询错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文