Re: deleting muliple feilds from a table using an array
| From: | Robin Vickery | Date: | Fri, 24 Mar 2006 21:20:24 +0000 |
| Subject: | Re: deleting muliple feilds from a table using an array | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-232562@lists.php.net to get a copy of this message | ||
On 24/03/06, benifactor <snorris17@cox.net> wrote:
>
> //$del will look like 38, 40, 43
>
> $query = "delete From news where id = '$del'";
>
> This code will only delete the first value of $idd. what i think is wrong is i have the
> incorrect syntax to delete multiple feilds from a table if some one can help me it would be greatly
> appreactiated.
>
DELETE FROM news WHERE id IN (38, 40, 43)
-robin