> Say a person checks the 1, 5, and 9 check boxes and hits delete.
> How do I know in the myEditNews.php file that those particular boxes
> were checked?? When I figure this out, I will use a loop to delete
> the news items one at a time from the database (unless there is a
> better way).
>
> My understanding of check boxes is that they are not sent from the
> form unless they are checked.
Correct.
> Am I making this hard on myself?
Yes. There's no need to have all the JavaScript and hidden fields.
<INPUT TYPE="checkbox" NAME="newsItem[]" VALUE="Item1"> Item 1<BR>
<INPUT TYPE="checkbox" NAME="newsItem[]" VALUE="Item2"> Item 2<BR>
<INPUT TYPE="checkbox" NAME="newsItem[]" VALUE="Item3"> Item 3<BR>
Notice the naming convention of the HTML checkbox elements! It's important
to have the square (array) brackets. Now, when user clicks the submit
button, your PHP script will have a newsItem array that will contain the
VALUEs from above for all those that were checked. (i.e. an array containing
'Item1' and 'Item3' if #1 and 3 were checked).
Now loop through the newsItem array deleting those records, or create a
single query to delete them all at once (off the top of my head, I _think_
something like "DELETE FROM table WHERE Item='Item1' OR Item='Item3'" will
work)
- Darryl
----------------------------------------------------------------------
Darryl Friesen, B.Sc., Programmer/Analyst [EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
----------------------------------------------------------------------
"Go not to the Elves for counsel, for they will say both no and yes"
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
