cat_order.php

The Shift Log is a database entry and display system that is built off of PHP and MySQL. The log use

<?PHP
		
		// Need a menu to select which item to edit
			$conn;
			$menu_sql = "SELECT cat_id, catname FROM category"; 
			$menu_result = mysql_query($menu_sql); 
			$menu_options = "";
			$menu_num_options = ""; //for possible future use
			while ($row = mysql_fetch_array($menu_result)) 
				{ 
				$id = $row["cat_id"];
				$menu = $row["catname"]; 
    			$menu_options.="<OPTION VALUE=\"$id\">".$menu; 
				}
				
	
		//Display category by the order id
			$conn;
			$query="SELECT * FROM category ORDER BY o_id";
			$result=mysql_query($query);
			mysql_close();
			if (mysql_num_rows($result) > 0) 
				{
   				echo'<table align="left" width="20%"  border="1" cellpadding="4" cellspacing="0" id="cat_order">';
					echo "<tr>";
					echo "<td colspan=\"2\">";
					echo "Category List";
					echo "</td>";
					echo "</tr>";
   				while ($row = mysql_fetch_assoc($result)) 
					{
					$name = $row['catname'];
					$o_id = $row['o_id'];
					print("</tr><tr>");
					echo "<td align=\"right\">";		
					echo $name;
					echo "</td>";
					echo "<td align=\"right\">";
					echo $o_id;
					echo "</td>";
  					echo "</tr>";
					}
   				echo '</table>';
			 }
				
			?>
	<form name="delete_menu" action="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>" method="post">
	<table width="38%" border="1" bgcolor="#CCCCCC">
  		<tr>
  			<td colspan="2" align="center"><p><strong>Select Category </strong></p>
		    </td>
    	</tr>
  		<tr>
    		<td width="38%">Select Link:</td>
    		<td width="62%" align="center"><select name="id"><option value=0>Select One<?PHP echo $menu_options;?></select></td>
			
  		</tr>
  		<tr>
    		<td colspan="2" align="center"><input type="submit" name="c_select" value="Modify" /></td>
		</tr>
	</table>
	</form>