Still Inserting Error

almystersv · February 11, 2008

Hi,

Im still having trouble with this query. Now its only writing (0,0,'','N') to the database.

Also do i need to loop the query or something in order for it to write all the users tasks to the database!?

TaskAdmin.php

<?php
session_start();
if (isset($_SESSION['username']) == false && ($_SESSION['type']) == 'user' && ($_SESSION['type']) == 'manager'){
	header("Location: login.php");
	exit();
}
require "connect.php";

$query = "select * from task where weekday = 'Monday' OR weekday = 'Everyday' ORDER BY taskID";
$result = mysql_query($query, $connection) or die ("Unable to perform query $query");

$query2 = "select * from employee where active = 'y'";
$result2 = mysql_query($query2, $connection) or die ("Unable to perform query $query2");
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Task Allocation</title>

<link rel="stylesheet" type="text/css"
href="mystylelogin.css" />

</head>

<body>
<?php
include ("headerAdmin.php");
include ("TasksHeaderAdmin.php");
?>


<div id="Adminheader">Monday Task Allocation</div>

<div id="AdminMainTable">
<table width="860" >
<hr />
<tr>
    <th width="142"><div align="left" class="style2">Task Name</div></th>
    <th width="262"><div align="left" class="style2">Description</div></th>
<th width="140"><div align="left" class="style2">Weekday</div></th>
<th width="140"><div align="left" class="style2">Assign</div></th>
  	</tr>
	<?php
	//Build Select Menu
	$employee_list = '<select name="empName"><option>Select an Employee</option>';
	while ($row2 = mysql_fetch_array($result2))
  		$employee_list .= '<option>'.$row2['fName'].' '.$row2['sName'].'</option>';
	$employee_list .= '</select>';

	while($row = mysql_fetch_array($result)) 
	{ ?>
  		<tr>
    		<td height="27"><?php echo $row['taskName']; ?></td>
    		<td><?php echo $row['taskDescription']; ?></td>
		<td><?php echo $row['weekday']; ?></td>
		<td>
		<form><?php echo $employee_list; ?></form></td>
  		</tr>
	<?php } ?></td>
  	</tr>
</table>
<form action="taskAdminQuery.php">
<input name="Save" type="submit" value="Allocate Tasks" />
</form>
</div>
</body>
</html>

TaskAdminQuery.php

<?php
require "connect.php";
//$empName = $_GET['empName'];
$empID = $_GET['empName'];
$emptaskweekDay = $_GET['weekday'];
$taskID = $_GET['taskID'];

$query =  "insert into emptask (taskID, empID, emptaskweekDay, complete) values ('".$taskID."','".$empID."','".$emptaskweekDay."','N')";
$result = @mysql_query($query, $connection) 
or die ("Error:".mysql_error());

$message1 = "Tasks Allocated Successfully.";
header("Location: TaskAdmin.php?message1=$message1");
exit();
//}
?>

Thanks you

Sign In

Still Inserting Error

Recommended Posts

almystersv

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information