function GetAllAvailable() { $sql = "SELECT * FROM kegs WHERE active = 1\n\t\t\tAND kegStatusCode != 'SERVING'\n\t\t\tAND kegStatusCode != 'SANITIZED'\n\t\t\tAND kegStatusCode != 'NEEDS_CLEANING'\n\t\t\tAND kegStatusCode != 'NEEDS_PARTS'\n\t\t\tAND kegStatusCode != 'NEEDS_REPAIRS'\n\t\t\tAND kegStatusCode != 'FLOODED'\n\t\tORDER BY label"; $qry = mysql_query($sql); $kegs = array(); while ($i = mysql_fetch_array($qry)) { $keg = new Keg(); $keg->setFromArray($i); $kegs[$keg->get_id()] = $keg; } return $kegs; }
<li><a href="keg_list.php">Keg List</a></li> <li>/</li> <li class="current">Keg Form</li> </ul> </div> <!-- Top Breadcrumb End --> <!-- Right Side/Main Content Start --> <div id="rightside"> <div class="contentcontainer med left"> <p> fields marked with an * are required <form id="keg-form" method="POST"> <input type="hidden" name="id" value="<?php echo $keg->get_id(); ?> " /> <table width="950" border="0" cellspacing="0" cellpadding="0"> <tr> <td> Label: <b><font color="red">*</color></b> </td> <td> <input type="text" id="label" class="mediumbox" name="label" value="<?php echo $keg->get_label(); ?> " /> </td> </tr>