Welcome Guest, Not a member yet? Register   Sign In
Problems creating an SQL query
#3

(This post was last modified: 01-04-2019, 12:53 PM by Wouter60.)

PHP Code:
$this->db
->select('p.content,p.id,p.userid,p.postid,p.nodeview,p.questionid,p.groupid,u.username,u.avatarpath')
->
from('posts p')
->
join('users u''p.userid = u.id')
->
where('p.userid',$user['id'])
->
where_not_in('p.nodeview', array('article','pm'))
->
order_by('p.datetimenumber''DESC')
->
limit(20,$page);
$query $this->db->get();
if (
$query->num_rows() > 0) {
 return 
$query->result();
}
else {
 
  return FALSE;


This will select the records where posts.nodeview is not 'article' and not 'pm'.
Is that what you need?
Reply


Messages In This Thread
Problems creating an SQL query - by desbest - 01-04-2019, 10:28 AM
RE: Problems creating an SQL query - by jreklund - 01-04-2019, 10:53 AM
RE: Problems creating an SQL query - by Wouter60 - 01-04-2019, 12:52 PM



Theme © iAndrew 2016 - Forum software by © MyBB