Can this be done?

bjkersey

I want to display a query result of a small table with the follow features.
Each row has three fields: 1. href to the action page on ID field 2.description and 3. a checkbox. The user may check none, one or more and then click on the link. Here is the question: how do I get the ID and the checked values to the action page?
TIA Bill

Anon

if($check1){}elseif($check2){}else{}

Anon

The name of the checkboxes have to be like name="variable[]" then you will get an array as result!

You can then view the content of the array with
echo "pre";
echo var_dump ($variable);
echo "/pre";

Hope this helps

bjkersey

I tried this in the link page (CompanyEdit.php)and got preNULL/pre. Not what I was expecting to see.
Here is the code.
<?php
$db = pg_connect("dbname=xxxxxx user=xxxxx");
$query = "SELECT * FROM cr_xxxxxxx";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$numrows = pg_numrows($result);
if (!$numrows) { printf ("No Data"); exit; }
$row=0;
printf ("<table border='0' >\n");
printf ("<tr>
<td><b>Xxxxxxxx ID</b></td>
<td><b>Description</b></td>
<td><b>Remove</b></td>
</tr>\n");
$chkbox="[]";
do
{
$myrow = pg_fetch_row ($result,$row);
printf ("<tr>
<td><a href='$host/CompanyEdit.php'>%s</a></td>
<td>%s</td>
<td align='center'><input type = 'checkbox' name='$chkbox$row+1'></td>
</tr>\n", $myrow[0], $myrow[1]);
$row++;
}
while ($row < $numrows);
printf ("</table>\n");
?>
Thanks Bill