//* Get blog in admin
public function getActiveBlogsInAdmin($page)
{
$table = $this->db->table('zd_blogs');
$table->select('*');
$table->join('zd_main_cats', 'zd_main_cats.main_cat_id = zd_blogs.blog_main_cat', 'left');
$table->join('zd_users', 'zd_users.user_id = zd_blogs.blog_user', 'left');
$table->where('zd_blogs.blog_status', 1);
$table->where('zd_blogs.blog_deleted', 0);
$table->orderBy('zd_blogs.blog_id', 'DESC');
$table->limit(5, $page);
$query = $table->get();
if($table->countAllResults() > 0)
{
return $query->getResult();
}
else
{
return FALSE;
}
}