How to get the highest value, lowest value and average value in mysql in php-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

How to get the highest value, lowest value and average value in mysql in php

给我你的怀抱 2017-05-18 10:51:53

702

There are two fields in database table A, one is the category, and the other is the price
How to calculate the highest value, lowest value, and average price of No. 11 in the category in PHP
One category corresponds to N pieces of price data such as
11, 100
2, 120
11, 101
11, 101
11, 55
11, 99
5, 88
2, 103
11, 170
5, 98

给我你的怀抱

reply all (3)

伊谢尔伦2017-05-18 10:53:53 3 floor

//数据库连接省略 $data=mysql_query("select MAX(price),MIN(price),AVG(price) from goods where category=11"); $row_data=mysql_fetch_row($data); echo 'MAX:'.$row_data[0].' MIN:'.$row_data[1].' AVG'.$row_data[2];