mod_sub_form.php

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

<?PHP
			//Menu the submenu
			$conn;
			$select_db;
			$sub_sql="SELECT sid, subcat_name FROM subcat"; 
			$sub_result=mysql_query($sub_sql); 
			$sub_options="";
			$sub_num_options="";  //for possible future use
			while ($row=mysql_fetch_array($sub_result)) 
				{ 
				$id=$row["sid"];
				$scat=$row["subcat_name"]; 
    			$sub_options.="<OPTION VALUE=\"$scat\">".$scat;
				$sub_num_options.="<OPTION VALUE=\"$id\">".$scat;  //for possible future use
				}
		?>
		<br />
	<!-- Modify Subcategory -->
	<form name="mod_sub" action="<?php echo $HTTP_SERVER_VARS['PHP_SELF']; ?>" method="post">
	<table color="CCCCCC"  width="35%"  border="1">
  		<tr>
  			<td colspan="2" align="center"><p><strong>Modify Subcategory</strong></p>
		    <p><strong><font size="-2" color="#FF0000">Warning: These changes will only apply to future posts, not posts that have already taken place</font></strong></p></td>
    	</tr>
  		<tr>
    		<td width="45%">Select Category:</td>
    		<td width="55%" align="center"><select name="oldsub"><option value="0">Select One<?PHP echo $sub_num_options;?></select></td>
  		</tr>
  		<tr>
    		<td>New Submenu Name: </td>
    		<td align="center"><input type="text" name="mod_subname"></td>
  		</tr>
  		<tr>
    		<td align="center"><input type="reset"></td>
    		<td><input type="submit" name="mod_sub" value="Submit" /></td>
  		</tr>
	</table>
	</form>