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>
