title: select count(*) from table of mysql in php
body: <p>I am able to get both the value and row of the mysql query result.</p>
  
  <p>But I am struggling to get the single output of a query. e.g.:</p>
  
  <pre><code>$result = mysql_query("SELECT COUNT(*) FROM Students;");
  </code></pre>
  
  <p>I need the result to display. But I am not getting the result.</p>
  
  <p>I have tried with the following methods:</p>
  
  <ol>
  <li><code>mysql_fetch_assoc()</code></li>
  <li><code>mysql_free_result()</code></li>
  <li><code>mysql_fetch_row()</code></li>
  </ol>
  
  <p>But I didn't succeed to display (get) the actual value.</p>