Re: Multiple deletes and updates...

You can use checkboxes to do it : <input type="checkbox" name="delrec[]" value="<?=$recid?>"> and in the code foreach($_POST["delrec"] as $ccc) { $res=mysql_query("delete from table_name where id= $ccc"); } HTH Mustafa ----- Original Message ----- From: <Tristan.Pretty@risk.sungard.com> To: <php-db@lists.php.net> Sent: Thursday, March 04, 2004 3:36 PM Subject: [PHP-DB] Multiple deletes and updates... > I simply can't get my head round this today.... > Probably easy, but I've been chocka, and brain is melting... > Anyhoo... > > If I have a table, with say, id(unique, auto inc), name, email, > membership_type > > I've listed them on a PHP page... > I want to add a checkbox to each row, so that I can select 1 or all, and > then perform an action on ALL selected (Either Delete, or change > membership_type) > I can do this with ease one by one, but I cant get my head round to more > than one with one submit button...? > > Can anyone nudge me in the right direction....? > I've seen this on the list before, but couldn't find it in the archive (I > may have imagined it?) > > cheers, > Tris... > > > ********************************************************************* > 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 >