title: Return the int result of sql query to php echo?
body: <p>A little help would be lifesaving. I have an sql query that works in phpMyAdmin and gives me the result i need.
  When i build this query into a php statement i cant seem to access the result (an integer)
  I literally need to echo the value, so i need to output for exanmple " your number is" result.</p>
  
  <p>here is my query:</p>
  
  <pre><code>$sqlstatement = "SELECT (SELECT `embark` FROM info ORDER BY `index_no` DESC LIMIT 1)-(SELECT `embark` FROM info ORDER BY `index_no` ASC LIMIT 1)";
  $sql_result = mysqli_query($connection, $sqlstatement) or die (" Couldn't execute the SQL calculate disembark statement********");
  </code></pre>
  
  <p>If anyone can help i would really appreciate it
  Scott</p>