dbconnect(); projects = database.cursor("SELECT * FROM project ORDER BY projectname") if(request.add) { if(request.mm2 != "" && request.dd2 != "" && request.yy2 != "") { var duedate ="'" + request.mm2 + "/" + request.dd2 + "/" + request.yy2 + "'" } else { var duedate = "null" } var opendate = request.mm1 + "/" + request.dd1 + "/" + request.yy1 database.execute("INSERT INTO actionitems (projectname, actionitem, requester, owner, duedate, opendate) VALUES ('" + request.projectname + "', '" + request.actionitem + "', '" + request.requester + "', '" + request.owner + "', " + duedate + ", '" + opendate + "')") redirect("projact.html?project=" + escape(request.projectname)); }

New Action Item
Project Name*
Action Item
Description
Requester
Owner
Open Date* / / (e.g. 8/7/1996)
Due Date / / (e.g. 8/20/1996)

* Required Fields