如何回显这个MySQL查询的结果？

Question

Here's my code:

include_once("config.php");                   
$database = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
$findnextsite = "SELECT MAX(id) FROM scraped_data";
echo $findnextsite;
$database->close();

Copy of my config.php file:

define("DB_HOST", "localhost");
define("DB_NAME", "my_database");
define("DB_USER", "my_username");
define("DB_PASS", "password");

The above code is displaying this when I refresh the page:

SELECT MAX(id) FROM scraped_data

I'm trying to get it to display to results of the query, not the query itself. Basically all I'm trying to do is find the highest id in my table and assign it to a variable to I can use it in a few places.

Answer 1

<?php
$records=mysql_query($findnextsite );
**while($scraped_data=mysql_fetch_assoc($records)) {
echo $Schools['Name'];**
}//end while
?>

Try using this piece of code for Echo.