title: MySQL query pulling one row and displaying first letter of result
body: <p>I think I need a basic PHP / MYSQL refresh, because nothing is working for me.</p>
  
  <p>My MYSQL Table has two rows of information.</p>
  
  <pre><code> $results = mysql_query("SELECT Name, Description FROM products");
   $results = mysql_fetch_assoc($results);
   print_r($results);
  </code></pre>
  
  <p>When printing this, all I get is one result. <code>Array ( [Name] =&gt; Banana [Description] =&gt; It's a lovely banana )</code>.  There are definitely two results in the table.  Why is this happening?</p>
  
  <p>Secondly, this loop only returns the first letter of each result, and I don't know why!</p>
  
  <pre><code>foreach($results as $res) {
  ?&gt;
      Name : &lt;?php echo $res['Name']; ?&gt;&lt;br /&gt;
      Description : &lt;?php echo $res['Description']; ?&gt;&lt;br /&gt;
  
  &lt;?php } ?&gt;
  </code></pre>
  
  <p>My brain is seriously scrambled today :(</p>