PHP Code:
foreach($_POST['100type'] AS $key=>$value) { // UPDATE 100 TYPE
    
mysql_query("UPDATE order_details_table SET block_quantity='{$_POST['100quantity'][$key]}', block_pallets='{$_POST['100pallets'][$key]}', block_extras='{$_POST['100extras'][$key]}' WHERE order_id='$id'")
    or die(
mysql_error()); 

the above code updates table data. It does not give me any errors but it does not update the table data. It fills in zero instead of the number it should be.

this code for checking post data
PHP Code:
echo '<pre style="text-align: left;">' print_r($_POSTtrue) . '</pre>'
shows that the data is there, but it does not update the table. Here is the posted data:
PHP Code:
...
[
100type] => Array
        (
            [
1] => 10.01
            
[2] => 10.02
            
[3] => 10.03
            
[4] => 10.04
            
[5] => 10.31
            
[6] => 10.83
            
[7] => 10.702
            
[8] => 10.772
            
[9] => 10.71
            
[10] => 10.72
            
[11] => 10.73
            
[12] => 10.74
        
)

    [
100perpallet] => Array
        (
            [
1] => 180
            
[2] => 240
            
[3] => 360
            
[4] => 576
            
[5] => 144
            
[6] => 288
            
[7] => 280
            
[8] => 560
            
[9] => 360
            
[10] => 480
            
[11] => 720
            
[12] => 1152
        
)

    [
100quantity] => Array
        (
            [
1] => 654
            
[2] => 458
            
[3] => 0
            
[4] => 0
            
[5] => 0
            
[6] => 0
            
[7] => 0
            
[8] => 0
            
[9] => 0
            
[10] => 0
            
[11] => 0
            
[12] => 0
        
)
...