can you help... in Pagination I modified View and Controller function

$config['total_rows'] = $this->db->count_all('ads');

needed two queries the first to get how many are all videos - rows???  how ^^ this work???



https://www.codeigniter.com/userguide3/d...:count_all

according to this ^^^ gets all rows of table but i want Only public[field public=1] videos count [exist and private[field public=0]]  what to do????