Storing form values in an array for posting - can it be done?

[nigel_belanger]

I have code that reads data from a database, then displays them (from an array). The displayed data is within a form and I want the user to be able to delete items from the listed items using a checkbox and also change quantity for each item.

The problem is that when you click the submission button, only the last record is sent. I need to find a way to store the submitted form values and store them in an array. Here is a snippet of the code that I'm using

$GetQuery = "SELECT * FROM table";
$GetInfo = mysql_query($GetQuery);
while ($p = mysql_fetch_row($GetInfo))
{
?>
<tr>
<form action="index.php?show=info" method="post">
<td align="center">

// $p[0] is a unique number to the item stored in the dbase

<input type="hidden" name="LineID[]" value="<?php echo $p[0]; ?>">
<input type="checkbox" name="DeleteInfo" value="DELETE">
</td>
<td>
<input type="text" name="Quantity" value="<?php echo $p[6]; ?>" size="2">
</td>
</tr>
<?php
}
?>
</form>

The next page will delete or change the data based on the return value of LineID.

What are your thoughts??

[nigel_belanger]

I'm guessing that this can't be done??

[ppera]

This is trivial.
Just insert all fields in forms as input strings with init value taken from DBase.

Pressing submit button will send all new values from input fields, also checkbox states etc.

[nigel_belanger]

<input type="text" name="Quantity" value="<?php echo $p[6]; ?>" size="2">

-- wouldn't that be what I am doing?? with the <?php echo ?> listed above?

[The_Chancer]

A few changes to be made as far as I can see....

$GetQuery = "SELECT * FROM table"; 
$GetInfo = mysql_query($GetQuery); 
while ($p = mysql_fetch_array($GetInfo)) 
{ 
?> 
<tr> 
<form action="index.php?show=info" method="post"> 
<td align="center"> 

// $p[0] is a unique number to the item stored in the dbase 

<input type="hidden" name="LineID[]" value="<?php echo $p[0]; ?>"> 
<input type="checkbox" name="DeleteInfo" value="DELETE"> 
</td> 
<td> 
<input type="text" name="Quantity" value="<?php echo $p[6]; ?>" size="2"> 
</td> 
</tr> 
<?php 
} 
?> 
</form> 

Try that to arrange your query into an array instead or just returning the row variables... using mysql_fetch_row would mean using:
while(list($a,$b,$c,$d,$etc...)=mysql_fetch_row($GetInfo))

Should definately be possible...