Untitled

//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);

 

?>