if (!$projid) { header("Location:projupd.php"); exit; } $db_name = "techproj"; $table_name = "projlist"; $connection = mysql_connect("localhost","dbuser","2al2") or die(mysql_error()); $db = mysql_select_db($db_name,$connection) or die(mysql_error()); if ($tech != "") { $dtacpt = date("Y-n-d"); $sql = " update $table_name set tech=\"$tech\",dtacpt=\"$dtacpt\" where projid=\"$projid\" "; } if ($sql != "") { $result = mysql_query($sql,$connection) or die(mysql_error()); } if ($dtcomp != "") { $sql2 = " update $table_name set dtcomp=\"$dtcomp\" where projid=\"$projid\" "; } if ($sql2 != "") { $result2 = mysql_query($sql2,$connection) or die(mysql_error()); } ?>
Project ID: |
Technician: |
Date Completed: |