Steve,
This should work as some basic sudo code. You are running into a number of issues with your usage of the foreach as it sounds like what you really want to do is walk through one array and grab the corresponding value from another.
<?php
// First check to make sure you are getting both fields
if(isset($_POST['name']) && is_array($_POST['name']) && isset($_POST['order']) && is_array($_POST['order']))
{
// Now assign them to easier to play with variables
$names=$_POST['name'];
$orders=$_POST['orders'];
// This tests for the same number of items as names
if (count($names) == count($orders))
{
$i=0;
while($i<=count($names))
{
$update_data = "UPDATE sections SET `order` = '$orders[$i]' WHERE name = '$names[$i]'";
$response = mysql_query( $update_data, $cnx );
if(mysql_error()) die ('database error<br>'.mysql_error());
}
}
}
?>
HTH,
Wolf
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
