Looping insert statement

[mrose]

Hi,

I'm currently attempting to insert multiple lines into a MySQL database table using a combination of SELECT results and user defined data on the same form on a page.

The problem is I have no idea of how to do this. I have attempted to count the number of rows from the select statement but cannot seem to pass this number accross to the next page whcih will run the looping insert statement. Is it a DO or a WHILE?

Please help,

Thanks,

Michael J Rose

[bastien]

show some code 🙂

[aaadee]

Me and Michael actually work together!

We have counted the num_rows = 3 in the previous page. If i change the $num_rows on next to $inserts to 3, then it enters all 3 of the inserts!

How can we make it read $num_rows.

Wont somebody help us!

<?

$inserts = $num_rows;

for ($i=0;$i<$inserts;$i++) {
include ("../connection.php");

$sql = "INSERT INTO emp_skills (result_id, skl_lev3, ab_id, system)
VALUES ('$result_id', '$skl_lev3', $ab_id, '$system')";
$sql_result = mysql_query($sql,$connection) or die ("Query Execute");

}
echo "<table cellpadding=0 cellspacing=0 border=1 width=760 align=center>";
echo "

<tr><br>
<td align=\"center\">Level: $skl_lev3</td>
</tr>
<tr>
<td align=\"center\">Ability ID: $ab_id</td>
</tr>
<tr>
<td align=\"center\">System: $system</td>
</tr>
<tr>
<td align=\"center\">Name: $result_id</td>
</tr>
</table>";

?>