$sql3="SELECT (crate_number + 1) as crate from crate_status ORDER BY crate_number DESC LIMIT 1";
$result2 = mysql_query($sql3);
// echo $sql;

// test for valid, grab data

$data = mysql_fetch_array($result2);

// html safe data
$f_data = array_map('htmlspecialchars', $data);

$sql="INSERT INTO crate_status (crate_number, Name, qty, procedural_code)
VALUES ('".$f_data['crate']."','".$_POST['Name']."','".$_POST['qty']."','2')";