\n"; }
// update record
if (!@$errorsAndAlerts) {
mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later)
$query = "INSERT INTO `{$TABLE_PREFIX}$tableName` SET
createdDate = NOW(),
createdByUserNum = '" .intval( @$CURRENT_USER['num'] ). "',
updatedDate = NOW(),
updatedByUserNum = '" .intval( @$CURRENT_USER['num'] ). "',
title = '".mysql_escape( $_REQUEST['title'] )."'";
mysql_query($query) or die("MySQL Error:
\n". htmlencode(mysql_error()) . "\n");
$newRecordNum = mysql_insert_id();
// adopt temp uploads (IMPORTANT - DON'T FORGET THIS STEP!!!)
adoptUploads($tableName, $preSaveTempId, $newRecordNum);
removeExpiredUploads(); // erase old expired uploads
// display thanks message and clear form
$errorsAndAlerts = "Thanks, we've added your record!";
$_REQUEST = array();
}
}
?>
Add Record