?>
// CSIRO Manufacturing Science and Technology, Preston Lab
// doedit page (hymod_bddb / boards)
require("defs.php");
pg_head("$bddb_label - Edit Log Entry Results");
if ($serno == 0)
die("the board serial number was not specified");
if (!isset($logno) || $logno == 0)
die("log number not specified!");
$query="update log set";
if (isset($date)) {
list($y, $m, $d) = split("-", $date);
if (!checkdate($m, $d, $y) || $y < 1999)
die("date is invalid (input '$date', " .
"yyyy-mm-dd '$y-$m-$d')");
$query.=" date='$date'";
}
if (isset($who))
$query.=", who='" . $who . "'";
if (isset($details))
$query.=", details='" . rawurlencode($details) . "'";
$query.=" where serno=$serno and logno=$logno";
mysql_query($query);
if(mysql_errno()) {
$errstr = mysql_error();
echo "\t\n";
echo "\t\t\n";
echo "\t\t\tThe following error was encountered:\n";
echo "\t\t
\n";
echo "\t\t\n";
printf("\t\t\t%s\n", $errstr);
echo "\t\t\n";
echo "\t\n";
}
else {
echo "\t\n";
echo "\t\t\n";
echo "\t\t\tThe log entry with log number $logno and\n";
echo "\t\t\tserial number $serno ";
echo "was successfully updated\n";
echo "\t\t
\n";
echo "\t\n";
}
?>