values for
$sound, $video, $lighting, $data, $projection, $racks, $vision, $camera, $set, $rigger, $driver, $graphics
are set to 1 if checked or no value if not
foreach ($_POST as $key => $value)
{
$$key=$value;
}
$fieldquery = "INSERT INTO field $id','$sound','$video','$lighting','$data','$projection','$racks','$vision','$camera','$set','$rigger','$driver','$graphics'
VALUES (')";
mysql_query($fieldquery)
or die ("Writing to field table failed");