Checkboxes and SQL.

[natleumas]

Hi, rather new to PHP,

i am on a oracle server with php.

anyway, i'm trying to display a list of checkboxes, from a sql queries. after the user checks some of the checkboxes, and submit the form, i would like to display the checkboxes that the user have submitted.

======================

code to display the checkboxes

$cmdstr = "SELECT knowledge_id, knowledge_name FROM knowledge";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed) or die("error executing sql statement<br>");
$nrows = ocifetchstatement($parsed, $results);

for($i = 0; $i < $nrows; $i++)
{
echo "<td><input type='checkbox' name='" . $results["KNOWLEDGE_ID"][$i] . "' value='" . $results["KNOWLEDGE_NAME"][$i] . "'>" . $results["KNOWLEDGE_NAME"][$i] . "</td>";
}

======================

code to display the selected checkboxes

$cmdstr = "SELECT knowledge_id FROM knowledge";
$parsed = ociparse($db_conn, $cmdstr);
ociexecute($parsed) or die("error executing sql statement<br>");
$nrows = ocifetchstatement($parsed, $results);
for($i = 0; $i < $nrows; $i++)
{
if(isset($HTTP_POST_VAR['$results["KNOWLEDGE_ID"][$i]']))
{
echo $HTTP_POST_VAR['$results["KNOWLEDGE_ID"][$i]'];
}
}

The problem now is that it does not go into the if statements, even thou the checkboxs are checked.

Thanks