title: Fetching Data From MySQL with $this->db
body: <p>So, I am trying to get the IMDb id for the from the table called videos. I tried it with these these are giving me error.
  Code 1:</p>
  <pre><code>      $imdb_id =  $this-&gt;db-&gt;get_where('videos', array('imdbid'))-&gt;result_array();
  </code></pre>
  <p>Code 2:</p>
  <pre><code>      $imdb_id =  $this-&gt;db-&gt;get('videos','imdbid');
  </code></pre>
  <p>code 3:</p>
  <pre><code>      $query = $this-&gt;db-&gt;query(&quot;SELECT * FROM videos;&quot;);
        $row = $query-&gt;row(0, 'videos');
        $imdb_id = $row['imdbid'];
  </code></pre>
  <p>Here is a screenshot of database table. Thank you for your contribution in advance.
  <a href="https://i.stack.imgur.com/SgE8t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SgE8t.png" alt="enter image description here" /></a></p>