각필드의 총합구하기에서... 정보
각필드의 총합구하기에서...본문
문의드립니다.
<?
$rowsum = sql_fetch(" select sum($ext10_01 + $ext10_02 + $ext10_03 + $ext10_04 + $ext10_05) as sum_value from $write_table ");
$sum_value = $rowsum[sum_value];
?>
<font color='red'>
<b>\ <?=number_format($sum_value)?>원 </b>
</font>
이걸 출력하니깐
$ext10_01
$ext10_02
$ext10_03
$ext10_04
$ext10_05
모두 수치가 있을땐 출력이되는데
하나라도 없을경우엔
---------------------------------------------------------------------
select sum(33,000 + 28,800) as sum_value from g4_write_notice
1064 : You have an error in your SQL syntax near '000 + 28,800) as sum_value from g4_write_notice at line 1
-----------------------------------------------------------------------
이렇게 뜹니다.
만약
$ext10_02
$ext10_05
없을경우에도 합을낼수가있을까요?
부탁드립니다.
<?
$rowsum = sql_fetch(" select sum($ext10_01 + $ext10_02 + $ext10_03 + $ext10_04 + $ext10_05) as sum_value from $write_table ");
$sum_value = $rowsum[sum_value];
?>
<font color='red'>
<b>\ <?=number_format($sum_value)?>원 </b>
</font>
이걸 출력하니깐
$ext10_01
$ext10_02
$ext10_03
$ext10_04
$ext10_05
모두 수치가 있을땐 출력이되는데
하나라도 없을경우엔
---------------------------------------------------------------------
select sum(33,000 + 28,800) as sum_value from g4_write_notice
1064 : You have an error in your SQL syntax near '000 + 28,800) as sum_value from g4_write_notice at line 1
-----------------------------------------------------------------------
이렇게 뜹니다.
만약
$ext10_02
$ext10_05
없을경우에도 합을낼수가있을까요?
부탁드립니다.
댓글 전체
즉.
<?
$all_sum = "";
if($ext10_01){
$all_sum += $ext10_01;
}
if($ext10_02){
$all_sum += $ext10_02;
}
if($ext10_03){
$all_sum += $ext10_03;
}
if($ext10_04){
$all_sum += $ext10_04;
}
if($ext10_05){
$all_sum += $ext10_05;
}
$rowsum = sql_fetch(" select sum($all_sum) as sum_value from $write_table ");
//생략
^^ 조금 무식하게 했나. ㅠ ;;
무식하게 하는게 때론..간단하게 처리가 ^^
<?
$all_sum = "";
if($ext10_01){
$all_sum += $ext10_01;
}
if($ext10_02){
$all_sum += $ext10_02;
}
if($ext10_03){
$all_sum += $ext10_03;
}
if($ext10_04){
$all_sum += $ext10_04;
}
if($ext10_05){
$all_sum += $ext10_05;
}
$rowsum = sql_fetch(" select sum($all_sum) as sum_value from $write_table ");
//생략
^^ 조금 무식하게 했나. ㅠ ;;
무식하게 하는게 때론..간단하게 처리가 ^^
$all_sum = "0";
for($i=1;$i<6;$i++)
{
$all_sum += ${ext10_0}.$i;
}
echo $all_sum;
for($i=1;$i<6;$i++)
{
$all_sum += ${ext10_0}.$i;
}
echo $all_sum;