?> <tr class='<?php echo $class; ?> '><td><b><?php echo $x; ?> </b></td><td><?php $startDay = $ssbArr['startDate']; $getDateDiff = mysql_query("SELECT DATEDIFF(now(),'{$startDay}') AS DiffDate"); $arrDate = mysql_fetch_assoc($getDateDiff); // echo $arrDate['DiffDate']+1; $beginday = date($startDay); $lastday = date("Y-m-d"); if ($beginday != $lastday) { echo $numOfDays = getBusinessDays($beginday, $lastday); } else { echo $numOfDays = 1; } ?> </td><td><?php echo $ssbArr['ssbID']; ?> </td><td class="custsubname"><?php echo $ssbArr['custSubName']; ?> </td> <td><?php echo $ssbArr['queue']; ?> </td><td><?php
echo $x; ?> </b></td><td><?php $startDay = $ssbArr['startDate']; $beginday = date($startDay); $lastday = date("Y-m-d"); //$getDateDiff=mysql_query("SELECT DATEDIFF(now(),'$startDay') AS DiffDate"); //$arrDate=mysql_fetch_assoc($getDateDiff); //echo $arrDate['DiffDate']+1; /*$beginday=date($startDay); $lastday=date("Y-m-d"); //echo $lastday; $nr_work_days = getWorkingDays($beginday,$lastday); echo $nr_work_days;*/ if ($beginday != $lastday) { echo getBusinessDays($beginday, $lastday); } else { echo 1; } ?> </td><td><?php echo $ssbArr['ssbID']; $queryStat = "SELECT * FROM openssbtime WHERE ssbID = '{$ssbArr['ssbID']}' and owner='{$ssbArr['owner']}'"; $resultStat = mysql_query($queryStat); if (mysql_num_rows($resultStat) == 0) { ?> <img src="images/addTime.png" height="12px" width="12px" onmouseover="showTime(<?php echo $x; ?> )" onmouseout="hideTime(<?php