$vote1="SELECT * FROM vote_details_urban WHERE booth_id = '$booth_id' AND year = '$year' ";$rsvote1=mysqli_query($con,$vote1);while($row1=mysqli_fetch_assoc($rsvote1)) { $value1=$row1["party1"]; $value2=$row1["party2"]; $value3=$row1["party3"]; $value4=$row1["party4"]; $value5=$row1["party5"]; $value6=$row1["party6"]; $value7=$row1["party7"]; $value8=$row1["party8"]; $value9=$row1["party9"]; $value10=$row1["party10"]; $value11=$row1["party11"]; $value12=$row1["party12"]; $value13=$row1["party13"]; $value14=$row1["party14"]; $value15=$row1["party15"]; $value16=$row1["party16"]; $value17=$row1["party17"]; $value18=$row1["party18"]; $value19=$row1["party19"]; $value20=$row1["party20"];}我想做的是從上述所有值中找到最大值,并找出$row1["party1"];最大值與最大值之間的差異,并找到$row1["party1"];與之間的差異$row1["party2"];這樣我就可以在下表中顯示結果,如果 party1 的投票多于獲勝者,它應該顯示 +value,如果 less-value。同樣,當將 part1 與 party2 進行比較時,我想在第二列中顯示其結果<table class="table table-bordered"><thead><tr><th>Winner Party</th><th>Difference From Winner Party</th><th>Difference From Party2</th> </tr></thead><tbody><tr><td></td><td></td><td></td></tr></tbody></table>
如何比較從數據庫中獲取的數據并獲取該特定行的最大值
ibeautiful
2023-03-04 16:46:02