updating column in multiple rows with 1 submit

[installer69]

I need to learn so although it would be great for someone to hand me a solution on a plate links to a tutorial or 2 would help more in the future. I have a table consisting of jobs to be issued. Columns are date, jobnumber, postcode and engineer. When I upload each day's work the engineer column is blank. I need to call the rows by a particular date to a html form, insert the relevent engineer for each row and press one submit button to update the records. Help would be greatly appreciated since I can currently only manage a form that updates each record one at a time and needs to be called by jobnumber. We do 120 a day and I may as well just type it into the access db that I wrote and email it every day!!

[Sxooter]

Well this ain't a tutorial, but it should help a bit. Build your forms to input arrays, it's much easier to parse. I.e.

$recs = 10;
$fields = array("name","address","phone");
for ($l=0;$l<$recs;$l++){
  print "Record Number: ".$l;
  for ($k=0;$k<count($fields);$k++){
    print $fields[$k].":";
    print '<input type="text" name="';
    print $fields[$k];
    print '['.$l.']';
    print '><BR>';
  }
}

Then when your data comes back it will be:

$name[0], $address[0], $phone[0] will be the first record, the second will be $name[1] and so on.

You can also change it so you get back:

$var[0]['name']
$var[0]['address']
$var[0]['phone']
$var[1]['name']