<td width="65"> <?php echo $day1; ?> </td> <td width="65"> <?php echo $today; ?> </td> <td width="159">View Details</td> </tr> <?php while ($row = mysql_fetch_array($city_result)) { $city_name = $cafe_details->getCityName($row['city']); $city_url = '<a href="city_details.php?city_id=' . $row['city'] . '">View</a>'; //getting cafeid of the corresponding city $result_cafe = $cafe_details->getCafeIdByCityId($row['city']); //reset to counter zero $screen_count_act = 0; $screen_count_reg = 0; $today_count = 0; $day1_count = 0; $day2_count = 0; $day3_count = 0; $day4_count = 0; while ($row = mysql_fetch_array($result_cafe)) { $cafe_user_id = $cafe_details->getCafeUIDByCafeId($row['id']); if ($cafe_user_id) { $reg_terminals = $cafe_details->getScreenReg($row['id']); $screen_count_reg = $screen_count_reg + intval($reg_terminals); $caf_scr_act = $cafe_details->getCafeScreensCount($cafe_user_id); $screen_count_act = $screen_count_act + $caf_scr_act;