AssCplWaring.php~

<?php
		$user_name = "root";
		$pass_word = "";
		$database = "schoolschedule";
		$server = "127.0.0.1";


		
		$db_handle = mysql_connect($server,$user_name,$pass_word);
		$db_found = mysql_select_db($database,$db_handle);
	
		$InitializeAssignmentTable = "UPDATE assignment SET PeriodTime='0',PeriodDay ='0'";
			$InitializeAssignmentResult = mysql_query($InitializeAssignmentTable);
		
		$Assembly = 'ASS';
		$Chapel= 'CPL';
		$InitializeAssembly = "DELETE from assignment WHERE SubjectID='$Assembly'";
			$InitializeAssemblyResult = mysql_query($InitializeAssembly); 
		$InitializeChapel = "DELETE from assignment WHERE SubjectID='$Chapel'";
			$InitializeChapelResult = mysql_query($InitializeChapel);

?>

<center>
<h2>Choose a Period Time and Day for Assembly</h2>
<br>
<table>
<form action="AssemblyChapel2.php" method="post">
	<tr>	
		<td>
			Subject:
		</td>	
		<td>
			Assembly
		</td>		
	</tr>
	<tr>			
		<td>			
			Period Time:
		</td>
		<td>
			<select name='PeriodTime'>
						<option value="1">1</option>
   	 				<option value="2">2</option>
   	 				<option value="3">3</option>
   	 				<option value="4">4</option>
   	 				<option value="5">5</option>
   	 				<option value="6">6</option>
   	 				<option value="7">7</option>
   	 				<option value="8">8</option>
   	 				<option value="9">9</option>
   	 				<option value="10">10</option>
   	 				<option value="11">11</option>
   	 				<option value="12">12</option>
			</select>
		</td>
	</tr>	
	<tr>
		<td>
			Day:
		</td>
		<td>
			<select name='PeriodDay'>
					   <option value="1">Monday</option>
					   <option value="2">Tuesday</option>
					   <option value="3">Wednesday</option>
					   <option value="4">Thursday</option>
					   <option value="5">Friday</option>
			</select>
		</td>
	</tr>
	<tr>
		<td>
			<input type="hidden" name="PrioritySubject" value="ASS">
			<input type="submit" value="Submit">
		</td>
	</tr>
</table>
</center>
</form>