//While loop to print out lables and receive crates

$i=0;
$number = $_POST['containers_received']; // just example

while ($i < $number)
{
$i++;
 if($i == $number + 3)	break;	// break after 10 times

// $i++;
// Do what you want to be repeated basically.


$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, po_ID, qty, procedural_code)
VALUES ('".$f_data['crate']."','".$_POST['po_ID']."','".$_POST['qty']."','2')";

// echo $sql;


if (!mysql_query($sql,$con))
  {
die('Error: ' . mysql_error());
  }
 echo '<H1>Item Received</H1>';



if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


// include "fire.php";
echo '<H1>Inventory Updated</H1>';

$sql2='select crate_number from crate_status ORDER BY crate_number DESC LIMIT 1';
$result = mysql_query($sql2);

// test for valid, grab data
$data = mysql_fetch_array($result);
$f_data2 = array_map('htmlspecialchars', $data);

// echo '<meta http-equiv="refresh" content="1;url=menu.php"/>';
// echo '<meta http-equiv="refresh" content="1;url=printcrate.php"/>';
$post_d = strpos($_POST['Name'], 'SLAB');
sprintf($result2);
if($post_d === false) {
echo '<H1>Generating Container Label</H1>';

//	echo '<meta http-equiv="refresh" target="_index" content="1;url=bcprint.php?Name='.$_POST['Name'].'&crate_number='.$f_data2['crate_number'].'">';

} else {

echo '<H1>Generating Slab Label</H1>';

// echo '<meta http-equiv="refresh"content="1;url=bcsprint.php?Name='.$_POST['Name'].'&crate_number='.$f_data2['crate_number'].'&qty='.$_POST['qty'].'">';

}
}
 mysql_close($con);

?>