while 로 일주일 조회시 공백있으면 채택완료

    <?

    $sql_search = " where (1) ";</p>

<p>    $sql_order = " order by mb_name";

    $sql = " select mb_name from {$g5['member_table']} {$sql_search} {$sql_order}";

    $result = sql_query($sql);    for ($i=0; $rows=sql_fetch_array($result); $i++) {

        $y++;

        $mb_name = $rows['mb_name'];

        ?>

        <tr >

            <td align=center><strong><?php echo $y ?></strong></td>

            <td align=center><strong ><?php echo $mb_name?></strong></td>

            <td align=center><strong >

            <div class="office_time_go">출근시간: </div>

            <div class="office_time_end">퇴근시간: </div>

            <div class="office_time_alltime">근무시간: </div>

            <div class="office_time_overtime">오버타임: </div>

            </strong></td>

        <?php

            $beforeDay = date("Y-m-d", strtotime($n_dahg." +$a day"));

            $sql_office_time = "SELECT wr_name,wr_2, wr_7,wr_15,wr_16,wr_3,wr_4 FROM $write_table WHERE wr_is_comment = 0 and wr_3 between '$n_dahg' and '$e_dahg' and wr_name ='$mb_name'";</p>

<p>            $result_office_time = sql_query($sql_office_time);



            <span style="color:#c0392b;">while($row=sql_fetch_array($result_office_time)){</span></p>

<p> </p>

<p>            $yoil = calculate_yoil($beforeDay);

        if($row['wr_3'] && (!$row['wr_2'] || strpos($row['wr_2'], "오전") || strpos($row['wr_2'], "오후")) ){

            ?>

            <td align=center> 

                    <div class="office_time_go"><?php echo substr($row['wr_3'], 11, 5); ?></div>

                    <div class="office_time_end"><?php if($row['wr_3'] != $row['wr_4']) echo substr($row['wr_4'], 11, 5); ?></div>

                

                <?php if(!$row['wr_7']){ ?> 

                    <div class="office_time_alltime" style="background-color:yellow;">

                <?php }else { ?> 

                    <div class="office_time_alltime" >

                <?php } ?> 

                    <font style="padding-top:3px"> <?php echo $row['wr_7'] ?></font>

                    </div></p>

<p>                <?php if($row['wr_2']){ ?> 

                    <div class="office_time_overtime" style="background-color:#92d050;">

                <?php }else { ?> 

                    <div class="office_time_overtime" >

                <?php } ?> <div><?php if($row['wr_2']){ echo $row['wr_2']; }else{ echo $row['wr_15']; } ?></div>

                    </div></p>

<p>            </td></p>

<p>            <?php

        }else if($row['wr_2']) {

            ?>

            <td >

            <div class="office_time_go"></div>

            <div class="office_time_end"></div>

            <div class="office_time_alltime"></div>

            <div class="office_time_overtime" style="background-color:#92d050;"><?php echo $row['wr_2'] ?></div></td>

            <?php

        }else{

            ?>

            <td>

            <div class="office_time_go"></div>

            <div class="office_time_end"></div>

            <div class="office_time_alltime"></div>

            <div class="office_time_overtime"></div>

            </td>

            <?php

        }

            ?></p>

<p>        <?php 

        }

            $sql_office_overtime = "SELECT wr_name,sum(wr_8),sum(wr_16) FROM $write_table WHERE wr_is_comment = 0 and wr_3 between '$n_dahg' and '$e_dahg'  and wr_name ='$mb_name'";

            $result_office_overtime = sql_query($sql_office_overtime);

            $row_office_overtime=sql_fetch_array($result_office_overtime);

            $office_time_color='';

            if($row_office_overtime['sum(wr_8)'] > 187200){

                $office_time_color = 1;

            }

        ?>

            <td align=center> 

            <div class="office_time_go"> </div>

            <div class="office_time_end"> </div>

            <div class="office_time_alltime" <?php if($office_time_color == 1){ ?> style="background:red;" <?php } ?> > <?php if($row_office_overtime['sum(wr_8)']) echo office_time($row_office_overtime['sum(wr_8)']); ?></div>

            <div class="office_time_overtime"> </div>

            </td></p>

<p>            <td align=center> 

            <div class="office_time_go"></div>

            <div class="office_time_end"></div>

            <div class="office_time_alltime"></div>

            <div class="office_time_overtime"><?php if($row_office_overtime['sum(wr_8)'] > 187200) echo office_time($row_office_overtime['sum(wr_16)']); ?></div>

            </td></p>

<p>        </tr>

    <?php

    } 

    ?></p>

<p>