multiple form values to database

[imnu]

I read many postings about multiple insert but still can't figure out a solution to my problem. I know it is simple, but you see, I am still new. Here is my problem:

I have a multiple-row table. The first column is a checkbox, and then a column with text-type input. I want to check a few boxes and put numbers in associated input boxes, and insert these paired-values to a database. I could do single value but not two or more values. Please help!

[imnu]

Ok, not interesting quesitons!

Hope some details would add some interests to it.

<?
if (isset($_POST[submit])) {
include 'db_connet.php';
if ($_POST[fid]!=0) {

$i = 0; 

foreach($fid as $key => $value1){//here is my problem. How do I get the values ($value2)  from another array $total[]?

$query2 = "insert into photo_order values ('', '$value1', '$value2', now())";

$query_db2 = mysql_query($query2) or die (mysql_error());

$i++; 
}	
}
}
?>

<form method=post action=post>
<table>
<tr><td><input type="checkbox" name="fid[]" value="1"></td><td><input type="text" name="total[]" size="1"></td></tr>
<tr><td><input type="checkbox" name="fid[]" value="2"></td><td><input type="text" name="total[]" size="1"></td></tr>
<tr><td><input type="checkbox" name="fid[]" value="3"></td><td><input type="text" name="total[]" size="1"></td></tr>
</table>
<input type="submit" name="submit" value="Send">
</form>

[nemonoman]

Why are you using 2 arrays? You could just as easily shove all the values into a single array...then your code would work, yes? Or am I missing something?