Comments on blog

[eluser]davehedgehog[/eluser]
Ok think Ive almost got it now, besides a small problem with the model~

Code:

$query2 = $this->db->query("select * from 'comment' where 'entry_id' = $id ORDER BY 'date' DESC");

  if($query2->num_rows() != 0){
  return $query2->row_array();
  }
  else
  {
   return false;
  }

This gives me the error~
Fatal error: Call to a member function num_rows() on a non-object

if I change the query to say~

Code:

$query = $this->db->get_where('comment',array('entry_id' => $id));

then it kinda works, as in it echos out the right comment for each article, but it gives me the first character for each coloumn entry, for all three fields~
name:2
Post:2
Date:2
name:9
Post:9
Date:9
name:j
Post:j
Date:j
name:b
Post:b
Date:b
name:2
Post:2
Date:2
name:a
Post:a
Date:a