Hi All,

I think I'm lost.....

Here's my problem, I have a searchUser.php which allows the user to enter the Employee ID and submit (which searches for the user). The result is displayed from the chunk of code below. I want to allow the user to append a particular field, therefore i added the select to the table...whenever i click the update button, nothing happens....

	   		  <table border='1' width='900'>
				<tr align='center' bgcolor='#339900'>
					<td><font face='verdana' size='2' color='white'><b>Employee ID</b></font></td>
					<td colspan='2'><font face='verdana' size='2' color='white'><b>Name</b></font></td>
					<td><font face='verdana' size='2' color='white'><b>Initials</b></font></td>
					<td><font face='verdana' size='2' color='white'><b>Username</b></font></td>
					<td><font face='verdana' size='2' color='white'><b>Access Level</b></font></td>
					<td colspan='2'><font face='verdana' size='2' color='yellow'><b>Select Access to be Granted and Update</b></font></td>
		for($counter=0; $myrow=mysql_fetch_row($result); $counter++)
			foreach($myrow as $key => $value)
			print("<td><font face='verdana' size='2'>$value</font></td>");
			print("<form action='update.php' method='post'>");
			print("<td><select name=accessType width='15'><option value=".$myrow[5].">Choose Access Level</option><option value=NULL>NULL</option><option value=User>User</option><option value=Admin>Admin</option><option value=SysAdmin>SysAdmin</option></select></td>");
			print("<td><input name='btnUpdate' type='submit' value='Update' /></td>");	

here is the update.php code:


	global $conn;
	$accessType = $_POST['accessType'];

	$btnUpdate = $_POST['btnUpdate'];

		$empNo = $_GET[$myrow[0]]; 
		$q1 = "UPDATE Operators SET accessLevel=".$accessType." WHERE EmployeeID =".$empNo;
		$result1 = mysql_query($q1, $conn) or die("Update not successful");