Editing and then resaving multiple rows to the table

[cmccomas]

I have a form I'm using and I'd like part of the form to be entered into one row of the table and the other part of the form entered into another row. I'll run PHP to display all rows from the table.

Simple example:
Row 1 ->
<input type="hidden" name="standing_id">
<input type="text" name="client_name">
<input type="text" name="client_job_title">

Row 2 ->
<input type="hidden" name="standing_id">
<input type="text" name="client_name">
<input type="text" name="client_job_title">

standing_id is a UNIQUE, primary key.

Can I just:

$query = "UPDATE standings SET client_name = '$client_name', client_job_title = '$client_job_title' WHERE standing_id = '$standing_id'";

[devinemke]

i suggest you collect the data as an array. a simple example:

<?php
// connect to db here

if (!isset($_POST['submit']))
{
  $result = mysql_query('SELECT * FROM standings') or exit(mysql_error());
  echo '<form action="" method="POST">';
  while ($row = mysql_fetch_assoc($result))
  {
    echo '
		client name: <input type="text" name="data[' . $row['standing_id'] . '][' . $row['client_name'] . ']"><br>
		client job title: <input type="text" name="data[' . $row['standing_id'] . '][' . $row['client_job_title'] . '"><br><br>
		';
  }
  echo '
  <input type="submit" name="submit" value="submit">
  </form>
  ';
}
else
{
  foreach ($_POST['data'] as $key => $value)
	{
    $sql = "UPDATE standings SET 
    client_name = '" . $value['client_name'] . "',
    client_job_title = '" . $value['client_job_title'] . "' 
    WHERE standing_id = '$key'";

echo $sql; // just for testing
}
}
?>