\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'] )."', sample = '".mysql_escape( $_REQUEST['sample'] )."'"; mysql_query($query) or die("MySQL Error:
\n". htmlspecialchars(mysql_error()) . "\n"); $recordNum = mysql_insert_id(); // adopt temp uploads adoptUploads($tableName, $preSaveTempId, $recordNum); removeExpiredUploads(); // erase old expired uploads // display thanks message and clear form $errorsAndAlerts = "Thanks, we've added your record!"; $_REQUEST = array(); $preSaveTempId = uniqid('x'); $recordNum = null; } } ?>