return the int result of sql query to php echo? : 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.

here is my query:

    $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********");

If anyone can help i would really appreciate it
Scott