Array

[stevenrhiggins]

I'm using a while loop to generate a list of numbers retrieved from a dbase. Each number has a checkbox associated with it. I need to be able to display the list of numbers "checked" when the form is submitted and then to update their values in the dbase.

I've checked the numerous items on this subject in the forums but I'm not having any luck. Any help would be appreciated.

[Anon]

How are you naming the checkboxes in the form? Calling them all, say "options[]" (with the "[]") will see the values of all those that are checked returned in an array called $options (browsers don't send back the values of unchecked checkboxes).

[stevenrhiggins]

Here's what I have. When I try to list all the $pin checked, I only get the last one selected.

while ($data=mysql_fetch_array($result))

{

$pin=$data[23];

print"<td>$pin</td>";

print"<td><input type='checkbox' name='pinactive' value='$pin'></td>";

    }

[Anon]

Exactly; you want the name to be 'pinactive[]' - then you'll get the whole array.

[cordex]

change this:
print"<td><input type='checkbox' name='pinactive' value='$pin'></td>";

to this:
print"<td><input type='checkbox' name='pinactive[]' value='$pin'></td>";

and your results will be stored in the array $pinactive

just like Hayley said ...

-ben

[Anon]

Calling it merely "pinactive" will cause the browser to send back to the server something like
"pinactive=12&pinactive=55&pinactive=104"

PHP will get this and effectively go:
$pinactive=12;
$pinactive=55;
$pinactive=104;
so you only get the last one.

Call it "pinactive[]" and you'll have the browser sending what amounts to
"pinactive[]=12&pinactive[]=55&pinactive[]=104"

Which PHP parses as equivalent to:
$pinactive[]=12;
$pinactive[]=55;
$pinactive[]=104;
Resulting in $pinactive containing the array(12,55,104).

[stevenrhiggins]

I'll give it a whirl. Thanks for your help!