Loop through this array help

[condoug]

Hi all

I need to loop through the array below and insert values into a database table. All of the values in this array will be inserted into that same table.

The unique value of each record inserted will be (for example the [124] key). This is the ID of an individual. Each individual has completed form fields on on my page and submitted the form which creates this array.

So, for each [124] record in the array, I need to assign the value of [documenttype][124] to a variable and so one thrugh the whole array and then insert into a database.

I hope I have explained my request clearly!

Any advice or explanation on how to achieve this will be greatly appreciated.

Many Thanks
Doug

Here is the array:

Array
(
    [documenttype] => Array
        (
            [124] => 1
            [127] => 2
        )

[tdnumber] => Array
    (
        [124] => 12876452
        [127] => 63446829
    )

[doiday] => Array
    (
        [124] => 04
        [127] => 21
    )

[doimonth] => Array
    (
        [124] => 06
        [127] => 11
    )

[doiyear] => Array
    (
        [124] => 2001
        [127] => 1999
    )
)

[dabaR]

Here's a prototype.

<?php
$form_data = Array
(
    'documenttype' => Array(124 => 1, 127 => 2), 
    'tdnumber' => Array(124 => 12876452, 127 => 63446829),
    'doiday' => Array(124 => 04, 127 => 21),
    'doimonth' => Array(124 => 06, 127 => 11),
    'doiyear' => Array(124 => 2001, 127 => 1999)
);
$data = array();
$ids = array();
foreach ($form_data as $key => $values) {
  foreach($values as $id => $value) {
    if (empty($data[$id])) { $data[$id] = array(); }
    $data[$id][$key] = $value;
  }
}

var_dump($data);

foreach ($data as $id => $values) {
  $sql = "UPDATE table SET ";
  foreach ($values as $column_name => $value) {
    $sql .= "$column_name = " . mysql_real_escape_string($value) . " ";
  }
  $sql .= "WHERE id = " . mysql_real_escape_string($id);
  echo $sql;
}