multiple update

[kclark]

I have a code that I am using to update multiple products at one time instead of one at a time. It works great, but I have updated it to include whether a product is active or not. My selection box is correct and it will update the db properly, but when the update list is initially loaded, it makes all products "Not Active". I have done an "if echo selected" statement but it is not working. Here is my code.

<form action='processprices' method="post" name="FormName"> <input type="submit" name="priceform" value="Update Prices"><br>
<?php 
$result = mysql_query("SELECT * FROM products where productcompany='$_POST[productcompany]' ORDER BY materialid, price desc");
// start a counter in order to number the input fields for each record
$i = 1;
while ($prices = mysql_fetch_array($result)) {
print "<table border=\"1\"><tr><td width=\"60\">{$prices['modelnumber']}<input type='hidden' size=\"15\" name='productid[$i]' value='{$prices['productid']}' /></td>
<td width=\"250\">{$prices['model']}<input type='hidden' size=\"15\" name='model[$i]' value='{$prices['model']}' /></td>
<td><input type='text' size=\"15\" name='price[$i]' value='{$prices['price']}' /></td>
<td>[COLOR="RoyalBlue"]<select name='active[$i]' size=\1\">
<option value='1' (if({$prices['active']} == \"1\") echo \"selected\")>Active</option>
<option value='0' (if({$prices['active']} == \"0\") echo \"selected\")>Not Active</option>
</select>[/COLOR]</td>
<tr>";
// add 1 to the count, close the loop, close the form, and the mysql connection
++$i;
}
print "</table><input type='submit' name='priceform' value='Update Prices'>";
print "</form>"; ?> 

The blue part is my problem.

[mrbaseball34]

Give this a try. Next time, try formatting your code where it is easier to read, too.

<form action='processprices' method='post' name='FormName'>
  <input type='submit' name='priceform' value='Update Prices'>
<?php 
$result = mysql_query("SELECT productid, model, modelnumber, price, active 
                       FROM products WHERE productcompany='$_POST[productcompany]' ORDER BY materialid, price desc");
// start a counter in order to number the input fields for each record
$i = 1;
while ($prices = mysql_fetch_array($result)) {
?>
  <table border='1'>
    <tr>
      <td width='60'>
        <?php echo $prices['modelnumber'] ?>
        <input type='hidden' 
               name='<?php echo productid[$i] ?>' 
               value='<?php echo $prices['productid'] ?>' />
      </td>
      <td width='250'>
        <?php echo $prices['model'] ?>
        <input type='hidden' 
               name='<?php echo model[$i] ?>' 
               value='<?php echo $prices['model'] ?>' />
      </td>
      <td>
        <input type='text' 
               size='15' 
               name='<?php echo price[$i] ?>' 
               value='<?php echo $prices['price'] ?>' />
      </td>
      <td>
        <select name='<?php echo active[$i] ?>' size='1'>
          <option value='1' <?php echo $prices['active']? 'selected' : ''  ?>>Active</option>
          <option value='0' <?php echo !$prices['active']? 'selected': '' ?>>Not Active</option>
        </select>
      </td>
    <tr>
<?php
  // add 1 to the count, close the loop, close the form, and the mysql connection
  ++$i;
} // while ($prices = mysql_fetch_array($result))
mysql_free_result($result);
?>
  </table>
  <input type='submit' name='priceform' value='Update Prices'>
</form>

BTW, take out one of the submit buttons, too.