如何从网页最大工资和最小工资中获取输出值

Question

<?php 

include_once('db.php');

$sq1= "SELECT MAX(salary),MIN(salary) FROM employees";

$query = $conn->query($sq1);

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

                                print_r($row); // here here which code is required to display only value.

}

?>

我只想显示值，但这种方法不能完全填充。

Answer 1

echo $row['MAX(salary)'];&nbsp;echo $row['MIN(salary)'];

Answer 2

您可以使用“as”别名SELECT MAX(salary) as maximum,MIN(salary) as minimum FROM employeesecho $row['minimum'];