Posted by Aaron Reimann on 10/02/94 11:42

I am trying to insert info if a checkbox is selected. The checkboxes
are created from this code (pulled from mysql):

##########
$ministry_info_query = "SELECT * FROM ministries WHERE inactive = 0
ORDER BY title"; // selecting all ministries that are active

$ministry_info_results = mysql_query($ministry_info_query, $mysql_link)
or die("Bad query: ".mysql_error());

// if the results are 0, the print this
if (mysql_num_rows($ministry_info_results) == "0") {
print "<br><strong>No ministries are in the
database.</strong>";

} else {

print "<table cellpadding=\"5\">\n";

while ($row = mysql_fetch_array($ministry_info_results)) {
print "<tr>\n";
echo "\t<td>$row[title]</td>\n";
echo "\t<td><input name=\"comments[]\"
type=\"checkbox\"
value=\"$row[id]\"></td>\n";
print "</tr>\n";
// ending the loop (while)
}

print "</table>\n";

}

mysql_free_result($ministry_info_results);
##########

Once the form is submitted, I need the ones that are checked to insert
the info into the "comments" table....i am kind of new at this...this
is kind of what I am thinking the code needs to look like:

$sql = "INSERT INTO comments ($row[people_id], id_ministries) VALUES(";

for($i=0;$i<count($comments);$i++) {
// DON'T KNOW WHAT TO DO

}

Does that make sense?

thank you for any advise.

[Back to original message]