Re: Checkboxes to gather rows to delete

Thats just it. I am just not sure what to do with the array before my "delete from" query now that I have it :-) Thanks... Lewis ----- Original Message ----- From: "1LT John W. Holmes" <holmes072000@charter.net> To: "Lewis Watson" <php@visionsix.com>; <php-db@lists.php.net> Sent: Monday, February 24, 2003 10:13 AM Subject: Re: [PHP-DB] Checkboxes to gather rows to delete > > I appreciate all of the quick replies. I do have globals off. Currently, I > > have the values for each ID being returned in a array.... Array ( [0] => > > 101 [1] => 201 ) where 101 and 201 were the id's of the rows I checked. I > > have to say I like the way of doing it that Mathieu has shown using the > > explode function. > > Thanks again. > > Lewis > > You already have an array of IDs you want to delete. Explode is for making > arrays, so what would you use it on? That doesn't make sense. > > $query = "DELETE FROM table WHERE rowID IN (" . > implode(',',$_POST['id_array']) . ")"; > > is the most efficient, easiest solution, but use whatever you understand. > > ---John Holmes... >