php mysql查询结果是否为空,如何检查MySQL结果是否在PHP中返回空？

How to check MySQL results are empty or not. If MySQL query results are empty then else condition should not be executed.

In case MySQL results in data there & in else condition my error my message is there but it is not showing any error message.

I have tried the following code but not showing any alert or echo message on the screen.

$sql = "select * from hall_search_data_1 where rent BETWEEN '".$_SESSION['amount1']."' AND '".$_SESSION['amount2']."'";

$res = mysql_query($sql);

if (!empty($res)) {

while ($row = mysql_fetch_row($res)) {

// here my data

}

} else {

echo "no results found";

}

解决方案<?php

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT id, firstname, lastname FROM MyGuests";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

while ($row = $result->fetch_assoc()) {

echo "id: " . $row["id"] . " - Name: " . $row["firstname"] . " " . $row["lastname"] . "
";

}

} else {

echo "0 results";

}

$conn->close();

?>