Inserting records to database from a tasble using repeated regions

mjl4975

Hi,

I am new to PHP and am having trouble coming up with a solution for this problem.

I am dynamically creating a table inside a form that lists the gear that a company uses and has a text field that people can enter the as number of each bit of equipment used. I need it to generate the gear list dynamically so if any equipment is changed in the database it is also changed on the form.

I can't find a way to insert all the equipment that is used, I am only able to insert the last bit of gear entered in the table.

Is it possible to do what I want this to do or am I completely off track.

Any advice would be much appreciated

Michael

Rohan_Hill

Of course it's possible 😃
How is your data (the pieces of equipment) stored?

mjl4975

I am trying to submit the variables gearID, scaffoldID & numberRequired.

When I submit the form the last row of variables are entered. I need submit all rows where a number has been entered in numberRequired and disregard any rows where the value of numberRequired is null.

Here is the repeated region:

<?php do { ?>
     <tr> 
            <td width="175" align="right" valign="middle"><?php echo $row_recSystem['gearName']; ?> <?php echo $row_recSystem['gearLength']; ?> </td>
             <td width="175" align="left" valign="middle"><input name="numberRequired" type="text" id="numberRequired" onFocus="MM_displayStatusMsg('Optional: Enter the amount of Gear required');return document.MM_returnValue" size="10" maxlength="10" /> 
              <input name="gearID" type="hidden" id="gearID" value="<?php echo $row_recSystem['gearID']; ?>" /> 
              <input name="scaffoldID" type="hidden" id="scaffoldID" value="<?php echo $row_recScaffold['scaffoldID']; ?>" /> 
             </td>
        </tr>
 <?php } while ($row_recSystem = mysql_fetch_assoc($recSystem)); ?>

cahva

Use name="gearID[]" instead of plain gearID. Do that to other inputs too. Now when you submit your form you got your products in a nice little array.