- <?php
- $stat=array();
- $n=0;
- foreach($_JOB as $key=>$value){
- $add_class_where=" `class`='".$key."' ";
- $query = "SELECT COUNT(*) FROM `****`
- LEFT JOIN `login` ON ****=****
- WHERE $add_class_where
- $db->setQuery( $query );
- $total_class = $db->loadResult();
- $stat[$n]=array('job'=>$value,'char_cnt'=>$total_class);
- $n++;
- }
- $query = "SELECT COUNT(*) FROM `****`";
- $db->setQuery( $query );
- $total_char = $db->loadResult();
- ?>
- <table>
- <?php for($i = 0; $i <= 75; $i++) {
- $proc="$stat[$i][char_cnt]"/" $total_char"*"100"; ?>
- <tr>
- <td><?php echo $i ; ?></td>
- <td><?php echo $stat[$i][job] ; ?></td>
- <td><?php echo $stat[$i][char_cnt] ; ?>[<?php echo round($proc,2) ; ?>%]</td>
- </tr>
- <?php }?>
- </table>