Arrays and tables using repeated regions

mjl4975

Hi,

I am trying to insert a gear list from a table that is created dynamically from a MySQL database using repeated regions.

The form objects are gearID (from Gear table), scaffoldID (from Scaffold table), noRequired (from gear_List table) and gearName (from Gear table).

I need to insert the form objects (gearID, scaffoldID, noRequired) into an array so they can be entered into the table (gear_List). This is where my problems start.

How do I go about inserting these objects into the array when they are built in the dynamic table.

Should the each of the form object be declared as arrays? Should the form objects be named gearID[], scaffoldID[] etc?

This is the code for the repeat region table at the moment:

<?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)); ?>

Any advice on how to tackle this problem whould be much appreciated.

theDog

erm... like this?

<html>
<head>
<title>Eh!</title>
</head>
<body>

<?php
// Connect to db

// Get data, or die nice
$result = @mysql_query("SELECT * FROM db");
if (!$result) {
echo("<p>Oops: " . mysql_error() . "</p>");
exit();
}
// Display in table
echo("<table border=\"1\" width=\"90%\" cellpadding=\"4\" ">\n");
while ( $row = mysql_fetch_array($result) ) {
echo("<tr>\n");
echo("<td>" . $row["gearID"]  . "</td>\n");
echo("<td>" . $row["scaffoldID"] . "</td>\n");
echo("<td>" . $row["gearName"] . "</td>\n");
echo("</tr>\n");
}
?>
</table
</body>
</html>

You hold the query results in the $row[] variable, by the name of the column, and repeat the display of table rows with the WHILE loop. When there are no more gizmos in the database, it will quit the loop and close the table.

That is, if i understand what you're trying to do. And/or unless i don't know what i'm talking about, which is another distinct possibility.

🙂

mjl4975

Thanks,

I will give it a try.