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

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)']; echo $row['MIN(salary)'];

Answer 2

您可以使用“as”别名

SELECT MAX(salary) as maximum,MIN(salary) as minimum FROM employees

echo $row['minimum'];