function GetById($id) { $sql = "SELECT * FROM kegTypes WHERE id = {$id}"; $qry = mysql_query($sql); if ($i = mysql_fetch_array($qry)) { $kegType = new KegType(); $kegType->setFromArray($i); return $kegType; } return null; }
<?php if (count($kegs) == 0) { ?> <tr><td class="no-results" colspan="99">No kegs :(<br>Perhaps you should add one?</td></tr> <?php } else { foreach ($kegs as $keg) { if ($keg->get_kegStatusCode() != null) { $kegStatus = $kegStatusManager->GetByCode($keg->get_kegStatusCode()); } else { $kegStatus = new KegStatus(); } if ($keg->get_kegTypeId() != null) { $kegType = $kegTypeManager->GetById($keg->get_kegTypeId()); } else { $kegType = new KegType(); } ?> <tr> <td rowspan="2" class="intborder"> <center><span class="kegsquare"><?php echo $keg->get_label(); ?> </span></center> </td> <td colspan="2" class="leftborder rightborder" style="vertical-align:middle; font-size:1.2em;"> <center><b><?php echo $kegStatus->get_name(); ?> </b></center>