MySQL查询/ PHP打印值如果匹配

问题描述：

I have made a sql query to fetch how many values exists for each color. This is the query:

$sql = "SELECT Color, count(Color) as Total FROM table WHERE (Color !='Red' AND Color !='White' AND Color !='Blu') GROUP BY Color ORDER By Total DESC";

This is the output of the query:

+--------+-------+
| Color  | Total |
+--------+-------+
| Orange |  2471 |
| Yellow |   337 |
| Black  |    82 |
+--------+-------+

Well now I would like to print in PHP the "Total" value "IF" the Color is Orange, or Yellow, etc...

Example: if Color=Orange I should see "2471" if Color=Yellow I should see "337" etc...

Thanks!

我做了一个sql查询来获取每种颜色存在多少个值。这是查询： p>

 $ sql =“SELECT Color，count（Color）as Total FROM table WHERE（Color！='Red'AND Color！='White'AND Color！='Blu'）GROUP BY Color  ORDER By Total DESC“;  pre> 
 
 这是查询的输出： p> 
 
 
 
 + -------- + ---  ---- + \ N | 颜色| 总计| 
 + -------- + ------- + 
 | 橙色|  2471 | 
 | 黄色|  337 | 
 | 黑色|  82 | 
 + -------- + ------- + 
  pre> 
 
 现在我想在PHP中打印“总计”值“IF  “颜色是橙色，或黄色等...  p> 
 
 
示例：
 nif颜色=橙色我应该看到”2471“
if颜色=黄色我应该看到”337“
etc  ...  p> 
 
 
谢谢！ p> 
  div>

答

<?php
$color="Orange";
while($row = mysql_fetch_array($sql)) {
    if($row['Color']==$color){
        echo $row['Total'];
    }
}
?>

MySQL查询/ PHP打印值如果匹配

相关推荐