Codeigniter Issue using mysql set variable

Try separate the query

 $this->db->query("SET @weekVideoCount := (SELECT COUNT(*) FROM videos v)"); $query= $this->db->query("SELECT @weekVideoCount");

php mysql codeigniter variables

you should know $this->db->query() execute only one sql statement just like mysql_query.

CodeHunter