title: The max value in a column with php
body: <p>I have a MySql table "MyTable" with the column "order"</p>
  
  <pre><code>order
  -----
  3
  4
  2
  1
  </code></pre>
  
  <p>I want to get the highest number. The sql statement works well inside MySql:</p>
  
  <blockquote>
    <p>SELECT MAX(order) FROM MyTable"</p>
  </blockquote>
  
  <p>But I do not know how to use it with php and echo it? Something like:</p>
  
  <pre><code>$result = mysqli_query($con, "SELECT MAX(order) FROM MyTable");
  </code></pre>