Re: Checkboxes to gather rows to delete
| From: | 1LT John W. Holmes | Date: | Mon, 24 Feb 2003 16:21:44 +0000 |
| Subject: | Re: Checkboxes to gather rows to delete | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25875@lists.php.net to get a copy of this message | ||
> 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
You don't have to do anything with it, just throw it into the line that I
gave you. Show the code you have now and someone can help you put it all
together.
---John Holmes...
> ----- 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...
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>