What does your HTML look like? Have you defined the delete checkbox as an array? For example:
<input type="checkbox" name="select[]" value="rowid" /> Notice the brackets to indicate an array. --Nicole --------------------------- Nicole Swan Web Programming Specialist Carroll College CCIT (406)447-4310 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, March 05, 2004 2:11 AM To: [EMAIL PROTECTED] Subject: Spam:[PHP-DB] Forms and more forms? I'm talking to a MySQL database that contains info on all downloads from our site. I list all these entries, on a PHP page. The table structure etc, are static, but the fields retrieved, are dynamic, based on the users search criteria. Within each result, I've added a small form, that posts that data, to an external site (salesforce.com). Each field looks like this: http://www.risk.sungard.com/del.gif But one can have entries on a page.. At present, a user can submit a field to salesforce one at a time, no probs, and I'll probably wanna keep it that way. However.. TO enable multiple deletions, I must place the whole table in another form. What happens is that no matter how many deletions I select, it only picks up the one at the top of the page, or none, if the top one isn't selected. I'm using the following PHP... if ($submit == 'DELETE SELECTED') { foreach($_POST[select] as $del) { $res = mysql_query("DELETE FROM $table_name WHERE id='$del'"); } } But I presume that the embedded forms that talk to sales force, are disrupting it... So I need to either: 1. find out how to let the page detect what's selected anotehr way.. OR 2. enable multiple post to salesforce.com, WITHOUT opening potentially dozens of new windows (one for each submision) Any takers on a unique way to acheive this? Tris.. (P.S. Glad you asked ;-) ) ********************************************************************* The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. *********************************************************************** -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
