I want to update rows and columns with one submit action

[seanpaulcail]

I want to update rows and columns with one submit action.

I created a loop that presents a table with updateable fields to the viewer.

I want to have a submit that sets the info.

in the "SET" command, can I have a loop?

here's the loop that presents the info:

while($row = mysql_fetch_row($result))

{

for ($column = 0; $column < 5; $column++)

{ 

    echo " $row[$column] "</td>";

}

}

Here's a link to the downloaded info page:
http://www.southerninvestmentmortgage.com/get6l_name.php

Can I use the same loop to set the info?
If so, then how.

Here's my attempt to create a loop that sets the posted variables, but it doesn't work.

Thanks

<?
@ $db= mysql_pconnect("localhost:3306", "a0022423", "preven66");

 if (!$db)
 {
 	echo "Error: Could not connect to database. Please try again later.";
 	exit;
 	}

mysql_select_db("a0022423");

while($row)

{

for ($column = 0; $column < 5; $column++)



{ $query = "UPDATE 30yrFixedConforming SET $row[$column]='$row[$column]'";
}
}

What am I doing wrong? Am I not grabbing the posted variables? I'm obviously not setting them.

Thanks

[bad76]

Originally posted by seanpaulcail

<?
  while($row)
  {
      for ($column = 0; $column < 5; $column++)
      { 
          $query = "UPDATE 30yrFixedConforming SET $row[$column]='$row[$column]'";
      }
  }
?>

What am I doing wrong?
[/B]

Hi,
you're missing WHERE clause. This UPDATE statement change ALL rows every time. You can do this putting a "WHERE ID=$thisid" to tell it what is the row to change. Something like this:

<?
  while($row)
  {
      for ($column = 0; $column < 5; $column++)
      { 
          $query = "UPDATE 30yrFixedConforming SET $row[$column]='$row[$column]' WHERE ID=$column";
      }
  }
?>

[seanpaulcail]

My info isn't getting posted.

Maybe you can look at my initial page and tell me why. Been racking my little brain all night.

here's the inital page. It downloads a table from the database and presents it to the viewer, each record in an updateable field.

<form action="30yrFixedConforming.php" method="post">
<? @ $db=mysql_pconnect ("localhost:3306", "a0022423", "password");

if (!db)
{
echo "error: Could not connect to the databsae. Please try again later.";
exit;
}
mysql_select_db("a0022423");
$query = "SELECT * FROM 30yrFixedConforming";




mysql_select_db("a0022423");

$query = "SELECT * from 30yrFixedConforming";



$result=mysql_query($query);



echo "<table><tr>";

while($row = mysql_fetch_row($result))

{

for ($column = 0; $column < 5; $column++)

{ 

    echo "<td><input class=textbox type=text size=13 maxlength=13 name='$row[$column]' value= '$row[$column]'></td>";

}

echo "</tr><tr>";

}


?>
</tr>
</table>
<table>
<tr><td align=center><input type=submit value="Submit >>"></form></td></tr>
</table>
</html>

here's alink if you need to see it live: http://www.southerninvestmentmortgage.com/get6l_name.php

thanks

[bad76]

Originally posted by seanpaulcail

<?
//...

    echo "<td><input class=textbox type=text size=13 maxlength=13 name='$row[$column]' value= '$row[$column]'></td>";

//...

?>

[/B]

This don't work.

Assigning value don't check the box.
To setup the checkbox, you have to echo CHECKED in the tag:

<?
//...

    echo "<td><input class=textbox type=text size=13 maxlength=13 name='$row[$column]' value= '1' ";
    if($row[$column]>0)
        echo " CHECKED></td>";
    else 
        echo "></td>";
//...

?>

Search in forum, there are many thread on this argument.