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;
 }
Example #2
0
			<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>