title: PDO::FETCH_ASSOC What is about PDO::FETCH_ARRAY?
body: <pre><code>&lt;?php
  $sth = $dbh-&gt;prepare("SELECT name, colour FROM fruit");
  $sth-&gt;execute();
  
  /* Fetch all of the remaining rows in the result set */
  print("Fetch all of the remaining rows in the result set:\n");
  $result = $sth-&gt;fetchAll();
  print_r($result);
  ?&gt;
  </code></pre>
  
  <p>The above example will fetch all of the remaining rows in the result set and output something similar to:</p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
          (
              [NAME] =&gt; pear
              [0] =&gt; pear
              [COLOUR] =&gt; green
              [1] =&gt; green
          )
  
      [1] =&gt; Array
          (
              [NAME] =&gt; watermelon
              [0] =&gt; watermelon
              [COLOUR] =&gt; pink
              [1] =&gt; pink
          )
  
  )
  </code></pre>
  
  <p>Is there any option to get a result like the one <code>my_sql_fetch_array</code> returns, which looks like this:</p>
  
  <pre><code>Array
  (
      [0] =&gt; Array
          (
  
              [0] =&gt; pear
              [1] =&gt; green
          )
  
      [1] =&gt; Array
          (
  
              [0] =&gt; watermelon             
              [1] =&gt; pink
          )
  
  )
  </code></pre>