almystersv Posted February 11, 2008 Share Posted 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 Link to comment https://forums.phpfreaks.com/topic/90578-still-inserting-error/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.