include "../classes/CafeMgmt.php"; /* * creating objects * objects for the above classes */ $cafe_act = new CafeActivation(); $cafe_mgmt = new CafeMgmt(); /* * get yesterdays d */ $yesterday = $_REQUEST['date']; //date("Y-m-d",mktime(0,0,0,date("m") ,date("d")-1,date("Y"))); /* * gettingvalues in result array */ $result = $cafe_act->getInstalledCafe($yesterday); $num = mysql_num_rows($result); ?> <h4>Number of screens Installed today: <?php echo $num; ?> </h4><table width="973" border="1"><tr><td>Cafe Id</td><td>Mac Id</td><td>Installed By</td><td>Time</td></tr> <?php while ($row = mysql_fetch_array($result)) { echo ' <tr>'; echo ' <td>' . $row['cafe_id'] . '</td>'; echo '<td>' . $row['mac_id'] . '</td> '; echo ' <td>' . $cafe_mgmt->getEmUserName($row['employee_id']) . '</td>'; echo '<td>' . $row['time'] . '</td>'; echo '</tr>'; }