title: mysql_fetch_array return only one row
body: <p>Ok,  I have the following code:</p>
  
  <pre><code>$array = mysql_query("SELECT artist FROM directory WHERE artist LIKE 'a%' 
          OR artist LIKE 'b%' 
          OR artist LIKE 'c%'");
      $array_result= mysql_fetch_array($array);
  </code></pre>
  
  <p>Then, when I try to echo the contents, I can only echo <code>$array_result[0];</code>, which outputs the first item, but if I try to echo <code>$array_result[1];</code> I get an undefined offset.</p>
  
  <p>Yet if I run the above query through PHPMyAdmin it returns a list of 10 items.  Why is this not recognized as an array of 10 items, allowing me to echo 0-9?</p>
  
  <p>Thanks for the help.</p>