any easy way to list UPDATE columns

[Drummin]

Did you echo out $sql as was suggested?

[batwimp]

Now that we've established the correct POST variable names, I think you need to add it to the if statement:

 

if ($indexName!="record_id" && $indexName!="action" && $indexName!="submitpass"){
$myUpdateList[] = "$indexName='$value'";
}

 

To remove it from the SQL query.

[Drummin]

Now that we've established the correct POST variable names, I think you need to add it to the if statement:

EXACTLY!!!!!!!!

 

So final should be

<?php
if(isset($_POST['submitpass']) && $_POST['submitpass']=="Submit Order"){
//recieve the variables
$roastturkey = $_POST['roastturkey'];
$broccoli = $_POST['broccoli'];
$brisket = $_POST['brisket'];
$carrots = $_POST['carrots'];       

if(isset($_POST['record_id']) && !empty($_POST['record_id'])){
$record_id=$_POST['record_id'];
$myUpdateList = array();
foreach($_POST as $indexName => $value){
if ($indexName!="record_id" && $indexName!="submitpass"){
$value=mysql_real_escape_string($value);
$myUpdateList[] = "$indexName='$value'";
}//if ($indexName!="record_id" && $indexName!="action")
}//foreach($_POST as $indexName => $value) 
$fields = implode(",", $myUpdateList);
$sql=("UPDATE testtable SET $fields WHERE id=$record_id");
$result=mysql_query($sql);
}//if(isset($_POST['record_id']) && !empty($_POST['record_id']))
}//if(isset($_POST['action']) && $_POST['action']=="submitform")
?>

We hope...