추출문의 드립니다. 정보
추출문의 드립니다.본문
elseif($list[$i][wr_7]=="success") echo "<img src='$board_skin_path/img/success.gif' align='absmiddle' border='0'> ";
elseif($list[$i][wr_7]=="nsuccess") echo "<img src='$board_skin_path/img/nsuccess.gif' align='absmiddle' border='0'> ";
한필드에 두개값으로 저장됩니다.
success = 10개
nsuccess = 12개
이런식으로 통계가 나오게 하는 방법좀 알려 주세요.
elseif($list[$i][wr_7]=="nsuccess") echo "<img src='$board_skin_path/img/nsuccess.gif' align='absmiddle' border='0'> ";
한필드에 두개값으로 저장됩니다.
success = 10개
nsuccess = 12개
이런식으로 통계가 나오게 하는 방법좀 알려 주세요.
댓글 전체
$count_sql = SELECT COUNT(CASE wr_7 WHEN 'success' THEN 1 END) AS success
, COUNT(CASE wr_7 WHEN 'nsuccess' THEN 1 END) AS nsuccess
FROM $write_table
$count = sql_fetch($count_sql);
success = $count[success]
nsuccess = $count[nsuccess]
, COUNT(CASE wr_7 WHEN 'nsuccess' THEN 1 END) AS nsuccess
FROM $write_table
$count = sql_fetch($count_sql);
success = $count[success]
nsuccess = $count[nsuccess]
<?
$su_cnt =0;
$nsu_cnt = 0;
elseif($list[$i][wr_7]=="success"){
echo "<img src='$board_skin_path/img/success.gif' align='absmiddle' border='0'> ";
$su_cnt++;
}elseif($list[$i][wr_7]=="nsuccess"){
echo "<img src='$board_skin_path/img/nsuccess.gif' align='absmiddle' border='0'> ";
$nsu_cnt++;
}
?>
이렇게 하시고 for 구문 끝나고 나서
echo("success 계 : ".$su_cnt);
echo("nsuccess 계 : ".$nsu_cnt);
두분너무나 감사한데 적용방법을 모르겠네요..초보입니다..자세히 부탁좀 드릴께요
<? if ($is_checkbox) { ?><td class="checkbox"><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<td class="subject">
<?
echo $nobr_begin;
echo $list[$i][reply];
echo $list[$i][icon_reply];
if($list[$i][wr_7]=="accept") echo "<img src='$board_skin_path/img/order.gif' align='absmiddle' border='0'> ";
elseif($list[$i][wr_7]=="success") echo "<img src='$board_skin_path/img/success.gif' align='absmiddle' border='0'> ";
elseif($list[$i][wr_7]=="nsuccess") echo "<img src='$board_skin_path/img/nsuccess.gif' align='absmiddle' border='0'> ";
else echo "<img src='$board_skin_path/img/order1.gif' align='absmiddle' border='0'> ";
if ($is_category && $list[$i][ca_name]) {
echo "<span class=small><font color=gray>[<a href='{$list[$i][ca_name_href]}'>{$list[$i][ca_name]}</a>]</font></span> ";
}
if ($list[$i][is_notice])
echo "<a href='{$list[$i][href]}'><span class='notice'>{$list[$i][subject]}</span></a>";
else
echo "<a href='{$list[$i][href]}'>{$list[$i][subject]}</a>";
if ($list[$i][comment_cnt])
echo " <a href=\"{$list[$i][comment_href]}\"><span class='comment'>{$list[$i][comment_cnt]}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
echo " " . $list[$i][icon_new];
echo " " . $list[$i][icon_file];
echo " " . $list[$i][icon_link];
echo " " . $list[$i][icon_hot];
echo " " . $list[$i][icon_secret];
echo $nobr_end;
?>
</td>
<td class="name"><?=$list[$i][name]?></td>
<td class="datetime"><?=$list[$i][datetime2]?></td>
<td class="hit"><?=$list[$i][wr_hit]?></td>
<? if ($is_good) { ?><td class="good"><?=$list[$i][wr_good]?></td><? } ?>
<? if ($is_nogood) { ?><td class="nogood"><?=$list[$i][wr_nogood]?></td><? } ?>
</tr>
<? } // end for ?>
<? if ($is_checkbox) { ?><td class="checkbox"><input type=checkbox name=chk_wr_id[] value="<?=$list[$i][wr_id]?>"></td><? } ?>
<td class="subject">
<?
echo $nobr_begin;
echo $list[$i][reply];
echo $list[$i][icon_reply];
if($list[$i][wr_7]=="accept") echo "<img src='$board_skin_path/img/order.gif' align='absmiddle' border='0'> ";
elseif($list[$i][wr_7]=="success") echo "<img src='$board_skin_path/img/success.gif' align='absmiddle' border='0'> ";
elseif($list[$i][wr_7]=="nsuccess") echo "<img src='$board_skin_path/img/nsuccess.gif' align='absmiddle' border='0'> ";
else echo "<img src='$board_skin_path/img/order1.gif' align='absmiddle' border='0'> ";
if ($is_category && $list[$i][ca_name]) {
echo "<span class=small><font color=gray>[<a href='{$list[$i][ca_name_href]}'>{$list[$i][ca_name]}</a>]</font></span> ";
}
if ($list[$i][is_notice])
echo "<a href='{$list[$i][href]}'><span class='notice'>{$list[$i][subject]}</span></a>";
else
echo "<a href='{$list[$i][href]}'>{$list[$i][subject]}</a>";
if ($list[$i][comment_cnt])
echo " <a href=\"{$list[$i][comment_href]}\"><span class='comment'>{$list[$i][comment_cnt]}</span></a>";
// if ($list[$i]['link']['count']) { echo "[{$list[$i]['link']['count']}]"; }
// if ($list[$i]['file']['count']) { echo "<{$list[$i]['file']['count']}>"; }
echo " " . $list[$i][icon_new];
echo " " . $list[$i][icon_file];
echo " " . $list[$i][icon_link];
echo " " . $list[$i][icon_hot];
echo " " . $list[$i][icon_secret];
echo $nobr_end;
?>
</td>
<td class="name"><?=$list[$i][name]?></td>
<td class="datetime"><?=$list[$i][datetime2]?></td>
<td class="hit"><?=$list[$i][wr_hit]?></td>
<? if ($is_good) { ?><td class="good"><?=$list[$i][wr_good]?></td><? } ?>
<? if ($is_nogood) { ?><td class="nogood"><?=$list[$i][wr_nogood]?></td><? } ?>
</tr>
<? } // end for ?>
