Hi,
I have a form with multiple tables, and I need to post the data into a single database table. Look at attached images.
tables.pngform.jpg

Here is a code example of how my form is generated:
PHP Code:
<?php
            $sql 
"SELECT * FROM blocks_table WHERE series='100 Series'"// 100 SERIES --------------------------------------------------------------------
            
$result mysql_query($sql)or die(mysql_error());
            
$series 100;
            
$rowcounter 0
            echo 
'<table class="styled-table">';
            echo 
'<tr><th>100 Series</th><th>Per Pallet</th><th>Quantity</th><th>Pallets</th><th>Extras</th></tr>';
            while(
$row mysql_fetch_array($result)){
                
$rowcounter++;
                echo 
'<tr><td>'.$row['type'].'</td>
                <td><input type="text" name="'
.$series.'perpallet'.$rowcounter.'" id="'.$series.'perpallet'.$rowcounter.'" style="width:50px;" value="'.$row['per_pallet'].'" readonly /></td>
                <td><input type="text" name="'
.$series.'quantity'.$rowcounter.'" id="'.$series.'quantity'.$rowcounter.'" style="width:50px;" value="0" onChange="getTotal('.$series.','.$rowcounter.');" /></td>
                <td><input type="text" name="'
.$series.'pallets'.$rowcounter.'" id="'.$series.'pallets'.$rowcounter.'" style="width:50px;" value="0" class="pallets" readonly /></td>
                <td><input type="text" name="'
.$series.'extras'.$rowcounter.'" id="'.$series.'extras'.$rowcounter.'" style="width:50px;" value="0" class="extras" readonly /></td>
                </tr>'
;
            }
            echo 
'</table>';
        
?>
        </div>
        <div class="left">
        <?php
            $sql 
"SELECT * FROM blocks_table WHERE series='150 Series'"// 150 SERIES --------------------------------------------------------------------
            
$result mysql_query($sql)or die(mysql_error());
            
$series 150;
            
$rowcounter 0;
            echo 
'<table class="styled-table">';
            echo 
'<tr><th>150 Series</th><th>Per Pallet</th><th>Quantity</th><th>Pallets</th><th>Extras</th></tr>';
            while(
$row mysql_fetch_array($result)){
                
$rowcounter++;
                echo 
'<tr><td>'.$row['type'].'</td>
                <td><input type="text" name="'
.$series.'perpallet'.$rowcounter.'" id="'.$series.'perpallet'.$rowcounter.'" style="width:50px;" value="'.$row['per_pallet'].'" readonly /></td>
                <td><input type="text" name="'
.$series.'quantity'.$rowcounter.'" id="'.$series.'quantity'.$rowcounter.'" style="width:50px;" value="0" onChange="getTotal('.$series.','.$rowcounter.');" /></td>
                <td><input type="text" name="'
.$series.'pallets'.$rowcounter.'" id="'.$series.'pallets'.$rowcounter.'" style="width:50px;" value="0" class="pallets" readonly /></td>
                <td><input type="text" name="'
.$series.'extras'.$rowcounter.'" id="'.$series.'extras'.$rowcounter.'" style="width:50px;" value="0" class="extras" readonly /></td>
                </tr>'
;
            }
            echo 
'</table>';
        
?>
        </div>
Inserting the data in the order_table is simple enough, because it is not repeating information. The data from the above tables (there are more than these two), will all be inserted into the same table order_details_table.

How do I loop through these tables, and insert the data in the database table???

thanks