php代码选择最大值并在表中显示最大值的计数

Question

表名投票者字段名称 - 政党名称、州、方向、候选人名称、区、选票表中的日期是明智的

BJP Maharashtra Nagpur-East Nitin Gadkari   Nagpur  3000    
Congress    Maharashtra Nagpur-East Lucky   Nagpur  2500    
BJP Maharashtra Nagpur-South    Rakesh  Nagpur  12000   
Congress    Maharashtra Nagpur-South    Shyam   Nagpur  15000   

我正在根据州、方向和地区的情况从表格中选择最大票数。并在下面显示投票。

现在我想问你如何获得上述查询结果并显示我的表中每个方向的最大值的计数。请建议我......我只需要显示最大值方向的计数。

对于前——方向票政党东 5000 印度卢比东 8000 aap那么东方向只有 1 个最大值，那么它显示计数 1..请告诉我....

<table class="bordered">
    <tr> 
    <?php           
        $sqlst = "SELECT DISTINCT state FROM voter_count";
        $resultst = mysql_query($sqlst);
        while($rowst = mysql_fetch_array($resultst,MYSQL_ASSOC))
        {
        ?>  
    <td> 
<table class="bordered">
    <thead>
    <tr>             
        <th colspan="3"><?php echo $rowst['state']; ?></th>
    </tr>

     <?php  
        $state = $rowst["state"];           
        $sqlco = "SELECT DISTINCT district,direction FROM voter_count where state = '$state'";          
        $resultco = mysql_query($sqlco);
        while($rowco = mysql_fetch_array($resultco,MYSQL_ASSOC))
        {
        ?>    
     <tr>   
         <?php      
        $district = $rowco['district'];         
        $direction = $rowco['direction'];       
        $sqlvotes = "SELECT  MAX(votes) AS Vote,direction FROM voter_count where state = '$state' AND district = '$district' AND direction = '$constituency'";              
        $resultvotes = mysql_query($sqlvotes);                      
        while($rowvotes = mysql_fetch_array($resultvotes,MYSQL_ASSOC))
        {               

        ?>   
         <th><?php echo $rowvotes['Vote']; ?></th>      
          <th><?php echo $rowvotes['direction']; ?></th>         
    </tr>
    <?php }  } ?>
    </thead>
    </table>
</td>
<?php } ?>
</tr>
</table>

Answer 1

不能 100% 确定您的最终表格需要是什么样子，但这只是一个开始(您不需要第一个查询，您可以通过一个查询完成您想要的操作):

  SELECT  MAX(votes) AS Vote,direction, state, district FROM voter_count
  group by direction, state, district

作为提到的评论之一，请参阅有关如何使用分组依据的链接: http://www.w3schools.com/sql/sql_groupby.asp