can i pass data from view to controller?

[eluser]gRoberts[/eluser]
Hi there,

As mentioned before showing any code, you would need to use the "in" statement when passing the PostID's.

You will need to change, or at least create a new method within your model to something like the following:

Code:

public function getComments($PostIDs)
{
  if(!is_array($PostIDs))
   $PostIDs = array($PostIDs);
  $this->db->select('comments.comment, comments.postId, comments.id, posts.id, comments.date, posts.userId');
  $this->db->join('posts', 'posts.id = comments.postId', 'left');
  $this->db->where_in('posts.id', $PostIDs);
  $q = $this->db->get('comments');
  $Ret = array();
  foreach($q->result() as $Comment)
   $Ret[] = $Comment;
  return $Ret;
}

Within your controller, as I had posted in my initial reply, you will see how the $Post->Comments is populated. I was getting all of the posts, then all of the comments related to those posts and then looping through the posts and assigning each posts comments to the post.

This is far better than looping through each of the posts and then querying the database for the list of comments.