如何获取所有记录（循环）

Question

Data :
Request Number : RO-001

Purchase Number: PO-16-001
Qty : 5
Item : Pencil
Price : 1.00
Total : 5.00

Purchase Number: PO-16-002
Qty : 2
Item : A4 Paper
Price : 4.00
Total : 8.00

Qty : 3
Item : Book
Price : 15.00
Total :45.00

Output Now :

RO-001 | PO-16-001 | 5 | Pencil | 1.00 | 5.00
RO-001 | PO-16-002 | 3 | Book | 15.00 | 45.00

Why I can't reach this record ?
RO-001 | PO-16-002 | 2 | A4 Paper | 4.00 | 8.00

        $total_amount ='';
    foreach ($rows AS $row) {
        if ($row['id_supplier'] == $id_supplier)
         {
$qtys = $row['qtys'];
$unit_rm = $row['unit_rm'];
$total = $row['total'];
$total_amount += $total;          
 echo '<em>'. htmlentities($qtys, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
        echo '<em>'. htmlentities($unit_rm, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
        echo '<em>'. htmlentities($total, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';}}

  foreach ($name_items AS $name_item) {

    echo $name_item;
     echo '<em>'. htmlentities($name_item, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
  }
echo '<em>'. htmlentities($inc_number, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
 echo '<em>'.htmlentities($cur_yr, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
     echo '<em>'. htmlentities($total_amount, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
 echo '<em>'. htmlentities($name_employee, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';
 echo '<em>'. htmlentities($autoid, ENT_COMPAT, 'UTF-8').'</em><br>&nbsp;';?>  <div class="form-group">
      <input type="hidden" id="inc_number" name="inc_number[]" value="<?php echo $inc_number;?>"/>
      <input type="hidden" id="autoid" name="autoid[]" value="<?php echo $autoid;?>"/>
      <input type="hidden" id="year"  name="year[]" value="<?php echo $cur_yr;?>"/>
      <input type="hidden" id="name_employee" name="name_employee[]" value="<?php echo $name_employee;?>"/>
      <input type="hidden" id="status_po" name="status_po[]"/>
      <input type="hidden" id="date" name="date[]"/>
      <input type="hidden" id="id_submit" name="id_submit[]"/>
      <input type="hidden" id="id_supplier" name="id_supplier[]" value="<?php echo $id_supplier; ?>"/>
 <input type="hidden" id="name_item" name="name_item[]" value="<?php echo $name_item; ?>"/>
  <input type="hidden" id="request_number" name="request_number" value="<?php echo $request_number;?>"/>

 <input type="hidden" id="unit_rm" name="unit_rm[]" value="<?php echo $unit_rm; ?>"/>

 <input type="hidden" name="qty[]" id="qty" value="<?php echo $qtys; ?>" class="form-control input-sm">

 <input type="hidden" name="total_amount[]" id="total_amount" value="<?php echo $total_amount; ?>" class="form-control input-sm">

<input type="hidden" name="amount[]" id="amount" value="<?php echo $total; ?>" class="form-control input-sm">
  </div><?php}  } }?>     <input type="submit" name="submit_autoid" id="submit_autoid" value="Submit Order" 
  class="btn pull-right btn success"/></a> 
   </form>       
 <?php
if (isset($_POST['submit_autoid'])){
$request_number=$_POST['request_number'];
$inc_number=$_POST['inc_number'];
$autoid=$_POST['autoid'];
$name_item=$_POST['name_item'];
$year=$_POST['year'];
$name_employee=$_POST['name_employee'];
$status_po=$_POST['status_po'];
$date=$_POST['date'];
$id_supplier=$_POST['id_supplier'];
$qtys=$_POST['qty'];
$unit_rm=$_POST['unit_rm'];
$total=$_POST['amount'];
$total_amount=$_POST['total_amount'];
$id_submit=$_POST['id_submit'];   
for($i=0; $i<count($inc_number); $i++){
        mysql_query("INSERT INTO tbl_autoid (request_number,inc_number,autoid,year,name_employee,status_po, date, id_supplier, total_amount, id_submit)
    VALUES ('$request_number', '".$inc_number[$i]."', '".$autoid[$i]."','".$year[$i]."','".$name_employee[$i]."','In Process',now(), '".$id_supplier[$i]."','".$total_amount[$i]."', '1')") or die('Error'); }

         for($m=0; $m<count($name_item); $m++){
mysql_query("INSERT INTO tbl_purchase_order (autoid,request_number,id_supplier,name_item,qty,unit_rm,amount, status, date, name_employee)
    VALUES ('".$autoid[$m]."','$request_number', '".$id_supplier[$m]."', '".$name_item[$m]."','".$qtys[$m]."','".$unit_rm[$m]."','".$total[$m]."','Done', NOW(),'".$name_employee[$m]."')") or die('Error'); }
  ?>
<script>
window.location="record.php?request_number=<?php echo $request_number; ?>";
</script>