Moketronics

CREATE TABLE tiles (
	tile_id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
	tile_name TEXT NOT NULL,
	quantity INT(6) UNSIGNED NOT NULL,
	old_lot_qty INT(6) UNSIGNED,
	nom_height DECIMAL(6,3) UNSIGNED NOT NULL,
	nom_width DECIMAL(6,3) UNSIGNED NOT NULL,
	nom_thick DECIMAL(6,3) UNSIGNED NOT NULL,
	exact_height INT(6) UNSIGNED,
	exact_width INT(6) UNSIGNED,

Moketronics

CREATE TABLE tiles (
	tile_id INT(6) UNSIGNED NOT NULL AUTO_INCREMENT,
	tile_name VARCHAR(80) NOT NULL,
	quantity SMALLINT(5) UNSIGNED NOT NULL,
	old_lot_qty SMALLINT(5) UNSIGNED,
	n_height FLOAT(3) UNSIGNED NOT NULL,
	n_width FLOAT(3) UNSIGNED NOT NULL,
	n_thick FLOAT(3) UNSIGNED NOT NULL,
	e_height SMALLINT(5) UNSIGNED,
	e_width SMALLINT(5) UNSIGNED,

Moketronics

CREATE TABLE tiles (
	tile_id SMALLINT(5)  UNSIGNED NOT NULL AUTO_INCREMENT,
	tile_name VARCHAR(80) NOT NULL,
	quantity SMALLINT(5) UNSIGNED NOT NULL,
	old_lot_qty SMALLINT(5) UNSIGNED,
	n_height FLOAT(3) UNSIGNED NOT NULL,
	n_width FLOAT(3) UNSIGNED NOT NULL,
	n_thick FLOAT(3) UNSIGNED NOT NULL,
	e_height FLOAT(5) UNSIGNED,
	e_height FLOAT(5) UNSIGNED,

Moketronics

	if (stripos($_POST['first_name'], 'first name...') !== false) {
		$first_name = str_ireplace('first name...', '', $_POST['first_name']);
		$first_name = sanitize_user( $first_name, true );
	} else {
		$first_name = sanitize_user( $_POST['first_name'], true );
	}
	
	if (stripos($_POST['last_name'], 'last name...') !== false) {
		$last_name = str_ireplace('last name...', '', $_POST['last_name']);
		$last_name = sanitize_user( $last_name );