I am posting details from a form; however, the form I am using can draw in details from several different sources. Now the problem I have is to determine what was my data source.

I can use foreach to provide the value of each data point but how can I get the name of the data point?

name=tbl_sod.sod_id
data=1871

Array ( [tbl_sod.sod_id] => 1871 [doc] => 3418499-015 [rev] => B [doc_desc] => SKID HARDWARE LIST [required_status] => [esod] => 1 [isod] => 1 [pages] => 1 [status] => [eng_error] => 11 [draft_error] => 21 [vendor_error] => 31 [sourcing_error] => 41 [value_eng] => 51 [requested_change] => 61 [spec_conflict] => 71 [direction_deficient] => 81 [schedule_issue] => 91 [mfg_error] => 101 [comment] => HELLO )

What is being identified is call the key. The following function will return the key.

key()

Cannot use the foreach and key function together.

Here is what I developed in the end

PHP Code:

if(!empty($_POST)){
 $sql='UPDATE '.key($_POST).' SET '; 
 while(list($key,$val)=each($_POST)){
  if(!empty($val)) $sql.=$key.'='.strtoupper(mysql_real_escape_string($val)).' '; 
  else    $sql.=$key.'=NULL '; 
 }
 reset($_POST);
 $sql.='WHERE '.key($_POST).'='.$_POST[key($_POST)];
 echo $sql;
// $result=query($sql);
} 


foreach ($arr as $key => $value) { echo "Key: $key; Value: $value
";}