정렬 문제 다시 질문 드려요~
본문
<?php
$year = date("Y",time());
$temp_board = 'client';//게시판 이름
$sql = "select * from g5_write_$temp_board ";
$result = sql_query($sql);
$subject_arr = array();
for($x=0; $row = sql_fetch_array($result); $x++){
$subject_arr[$x] = $row;
}
$rowsum = sql_fetch("select sum(wr_3) as sum_in from `g5_write_kucun` where mb_id='xiaoshou' and Year(wr_4) = '$year' ");
$sum_total_all = $rowsum['sum_in'];
$all_zong = number_format($sum_total_all);
?>
<div class="kc_row_2">
<ul>
<?php for($x=0; $x<count($subject_arr); $x++){?>
<?php
$item_list = $subject_arr[$x]['wr_subject'];
$rowsum = sql_fetch("select sum(wr_3) as sum_in from `g5_write_kucun` where mb_id='xiaoshou' and Year(wr_4) = '$year' ");
$sum_total_all = $rowsum['sum_in'];
$all_zong = number_format($sum_total_all);
$rowsum_c = sql_fetch("select sum(wr_3) as sum_in from `g5_write_kucun` where wr_subject='$item_list' and mb_id='xiaoshou' and Year(wr_4) = '$year' order by sum_in asc");
$sum_total_c = $rowsum_c['sum_in'];
if($sum_total_c){
$ea_zong = number_format(str_replace("-","","$sum_total_c"));
}
?>
<li>
<div class="kc_title_2">
<div class="title"><?php echo $subject_arr[$x]['wr_subject'] ?></div>
<div class="kc_data_2">
<?php
echo ' <span class="sl_zong">¥ '.$ea_zong.'</span>';
$pingjun = number_format($sum_total_c / $sum_total_all , 4)*100;
echo '<span class="sl_ping">'.$pingjun.'%</span><br>';
?>
</div>
</div>
</li>
<?php }?>
</ul>
</div>
짜집기 해서 아래와 같이 구현을 했는데요...
정렬을 큰숫자부터 할려고 하는데 array, order by 해보고 하는데 도저히 안나오네요...
이론으론 숫자크기대로 다른게시판에서 불러오는 네임순서를 바꾸고 네임에 매치되는 금액이 표시되게 하는겁니다.
짜집기의 한계인거 같습니다.
감사합니다.
!-->답변 1
<?php
$year = date("Y");
$rowsum = sql_fetch("select sum(wr_3) as sum_in from `g5_write_kucun` where mb_id='xiaoshou' and Year(wr_4) = '$year' ");
$sum_total_all = $rowsum['sum_in'];
$sql = "
select wr_subject, sum(wr_3) as sum_in
from g5_write_kucun
where mb_id = 'xiaoshou'
and Year(wr_4) = '$year'
group by wr_subject
order by sum_in desc
";
$result = sql_query($sql);
?>
<div class="kc_row_2">
<ul>
<?php for($i = 0; $row = sql_fetch_array($result) ; $i++){
$ea_zong = number_format(str_replace("-", "", $row['sum_in']));
$pingjun = number_format($row['sum_in'] / $sum_total_all , 4) * 100;
?>
<li>
<div class="kc_title_2">
<div class="title"><?php echo $row['wr_subject'] ?></div>
<div class="kc_data_2">
<?php
echo ' <span class="sl_zong">¥ '.$ea_zong.'</span>';
echo '<span class="sl_ping">'.$pingjun.'%</span><br>';
?>
</div>
</div>
</li>
<?php }?>
</ul>
</div>
답변을 작성하시기 전에 로그인 해주세요.