title: Display multiple sql query results using php
body: <p>Ok so I've searched and searched but still struggling to resolve my problem. This is my current php coding: </p>
  
  <pre><code>$show = "Select effectiveness, round((Count(effectiveness)* 100 / (Select Count(*) From acupuncture))) as Score
  From acupuncture
  Group By effectiveness
  ORDER BY Score DESC";
  $result = mysql_query ($show);
  
  WHILE($show = mysql_fetch_array($result))
  {
  $field1 = $show[effectiveness];
  $field2 = $show[Score];
  
  echo "$field1: ";
  echo "$field2%&lt;br&gt;&lt;br&gt;";
  }
  </code></pre>
  
  <p>In addition to displaying the above I would also love to display the number of rows in the table. I know the sql code is:</p>
  
  <pre><code>"SELECT COUNT(id) AS entries FROM acupuncture"
  </code></pre>
  
  <p>Problem is when I try to input this into my php page I keep getting errors. I want to show both SELECT statement results on the one php page. If someone can help I would greatly appreciate it.</p>
  
  <p>Thank you
  Shikz</p>
  
  <p>All good, problem has been fixed. Thanks for all your help :) P.S. This is the code I inputted:</p>
  
  <pre><code>$size = @mysql_query("SELECT COUNT(*) AS `total` FROM acupuncture");
  $query = mysql_fetch_array($size);
  echo "Number of entries: ";
  echo $query['total'];
  echo "&lt;br&gt;&lt;br&gt;";
  </code></pre>
  
  <p>I was writing up the php code incorrectly before, but now all good. Thanks again.</p>