|
|
Posted by Aaron Reimann on 06/14/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.
Navigation:
[Reply to this message]
|