adding several lines to a db table

[zzz]

OK, this is probably very basic, but I'm puzzled:

I have sevaral lines in a table. I need to click a button and add all these lines to another table. I can do it one row at a time, but how can I post all at once?

[kevinsequeira]

use this format to insert mulitple rows in one INSERT query

INSERT INTO table VALUES ('a', 1, 1, 1), ( 'b', 2, 2, 2)

reg
kevin

[zzz]

I don't know how many rows I may have...

[kevinsequeira]

post your code

reg
kevin

[zzz]

This is how the row is generated:

while ($myrow = mysql_fetch_row($result))
{
printf("<tr><td>%s</td><td>%s</td><td>$%s</td><td>%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4]);
$total += $myrowt[4];
}

processpage.php

$update = ("insert into TBL2 (val1, val2, val3, val4) values ('$val1', '$val2, '$val3', '$val4')");
mysql_query($update);

[kevinsequeira]

u are having a form for every row in the resultset ??? meaning you have a submit button[not shown in ure code though] on every line in the table ???

reg
kevin

[zzz]

Please disregard the form tags in the code I posted. I do have a table that I need to process a line at a time. And the code above works fine.

In another table the rows are generated in a similar fasion but I'd like to process it all at once. Shall I just put the form outside the loop?

<form method=POST action=\"processpage.php\">

while ($myrow = mysql_fetch_row($result))
{
printf(" <tr><td>%s</td><td>%s</td><td>$%s</td><td>%s</td></tr> \n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4]);
$total += $myrowt[4];
}
</form>

That doesn't sound right, does it?

[kevinsequeira]

well im not sure what it is you need to do.

from what i gather you have a single form on a page within which u generate form elements by going through a query resultset. then when u click submit you want to enter all the rows at a time is that right ??

i need you to post the actual html code that u have for the page.
are u getting text input fields that user edits or what ??
is the final html something like this
<form name=xyz action=xyz_action.php method=post>
1st row of input type=text
2nd row of input type=text
3rd row of input type=text
.
.
.

<input type=submit>
</form>
reg
kevin

[zzz]

yes, you are close.

Just like you put it I have a dynamically generated table through

while loop. At teh bottom of the table I total the results and would like on submit update one table with the total resulta and then post each row of that dynamic table to another database table.

My question is: how do I insert these rows into a database table one at a time with one click instead of doing one line at a time which I already know how to do...

[kevinsequeira]

can you post the actual code that you are using to generate this form

reg
kevin

[zzz]

Yes, sorry about that. Here's the code :

<table border=0 cellspacing=1 cellpadding=0 width=100% CLASS=regularText bgcolor="#ffffff">
<?
$result = mysql_query("SELECT * FROM TABL where memID = '$memID'");
$query = mysql_num_rows($result);
while ($myrow = mysql_fetch_row($result))
{
printf("<form method=POST action=\"process.php\"><tr><td><input type=submit value=\"Submit\"></td><td>&nbsp;%s&nbsp;</td><td>&nbsp;%s</td><td>$%s</td><td>%s</td><td>$%s</td></tr><input type=hidden name=username value=".$username."><input type=hidden name=val1 value=\"%s\"><input type=hidden name=val2 value=\"%s\"><input type=hidden name=val3 value=\"%s\"><input type=hidden name=val4 value=\"%s\"><input type=hidden name=val5 value=\"%s\"><input type=hidden name=memID value=". $memID ."></form>\n",
$myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5]);
}
?>
</table>

this is what I use to process a line at a time, and I'd liek to process it all at once.