Update multiple rows

[franwpd]

I have ran this code before and it worked but not it won't update. Can anyone see what I am doing wrong?

<?
if(isset($_POST[sort_invest]))   {   // if form was submitted

   $id = $_POST['sel_record'];
   $sort = $_POST['sort'];

for($i=0;$i<$count;$i++){

$sql = "UPDATE invest SET id='$id[$i]', sort='$sort[$i]' WHERE id='$id[$i]'";

  $sql_result = mysql_query($sql,$con)
  or die (mysql_error());      
   }
     }

// if form was submitted or if it came from another page
if (isset($_POST['order_invest']) || isset($_POST['sort_invest'])) {   

?>       

      <p><strong>Order Invest</strong></p>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">     

<?   

$sql = "SELECT id, sort, title FROM invest ORDER BY sort ASC";
$sql_result = mysql_query($sql,$con) or die(mysql_error());

 while ($row = mysql_fetch_array($sql_result)) {   
        $id = $row["id"];     
        $title = $row["title"];
        $sort = $row["sort"];
?>
          <input type="hidden" name="sel_record[]" value="<? echo "$row[id]"; ?>">

<table width="545" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="69"><input type="text" name="sort[]" value="<? echo "$row[sort]"; ?>" size="3"></td>
    <td width="476"><? echo "$row[title]"; ?></td>
  </tr>
</table>

<br>
<?
}
  }
?>

        <input name="sort_invest" type="submit" value="Sort">
  </form>

[bradgrafelman]

Your for() loop uses an undefined variable $count.

Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

[franwpd]

I changed it to this but it didn't work.

for($i=0;$i<count($id);$i++){

[franwpd]

I am a beginner...Can anyone help?

[cretaceous]

probably not the problem but you should be using long php tags
use this: <?php
not this <?

and this line

$sql = "UPDATE invest SET id='$id[$i]', sort='$sort[$i]' WHERE id='$id[$i]'";

is like saying

... set id =apple, sort=something where id =apple

so setting the id is pointless

[franwpd]

After spending a lot of time rearranging, changing, testing and researching, I finally caught on. Thanks!

$id = $_POST['sel_record'];
$sort = $_POST['sort'];

for($i=0;$i<count($id);$i++){

$sql = "UPDATE invest SET sort='$sort[$i]' WHERE id='$id[$i]'";

	$sql_result = mysql_query($sql,$con)
	or die (mysql_error());