function GetAllActive() { $sql = "SELECT * FROM beers WHERE active = 1 ORDER BY name"; $qry = mysql_query($sql); $beers = array(); while ($i = mysql_fetch_array($qry)) { $beer = new Beer(); $beer->setFromArray($i); $beers[$beer->get_id()] = $beer; } return $beers; }
<li><a href="beer_list.php">My Beers</a></li> <li>/</li> <li class="current">Beer Form</li> </ul> </div> <!-- Top Breadcrumb End --> <!-- Right Side/Main Content Start --> <div id="rightside"> <div class="contentcontainer med left"> <p> Fields marked with <b><font color="red">*</font></b> are required.<br><br> <form id="beer-form" method="POST"> <input type="hidden" name="id" value="<?php echo $beer->get_id(); ?> " /> <input type="hidden" name="active" value="<?php echo $beer->get_active(); ?> " /> <table width="800" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="100"> <b>Name:<font color="red">*</font></b> </td> <td> <input type="text" id="name" class="largebox" name="name" value="<?php echo $beer->get_name();