<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;
