Re: [PHP] deleting muliple feilds from a table using an array
thanks all, very helpful!
- Original Message -
From: "Brady Mitchell" <[EMAIL PROTECTED]>
To: "benifactor" <[EMAIL PROTECTED]>; "php"
Sent: Friday, March 24, 2006 1:21 PM
Subject: RE: [PHP] deleting muliple feilds from a table using an array
> -Original Message-
> example code:
> //implode the value of the submitted form
> //$del will look like 38, 40, 43
> $del = implode(",", $idd);
> //create query for the deletion of values from submited form
> $query = "delete From news where id = '$del'";
> //execute query
> mysql_query($query) or die(mysql_error());
> //echo sucess message
> echo("The Post has been deleted...");
>
>
> here is what my problem is...
>
> 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.
$query = "delete From news where id IN($del)";
Take a look at
http://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html. The
user comments are helpful.
Brady
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] deleting muliple feilds from a table using an array
> -Original Message-
> example code:
> //implode the value of the submitted form
> //$del will look like 38, 40, 43
> $del = implode(",", $idd);
> //create query for the deletion of values from submited form
> $query = "delete From news where id = '$del'";
> //execute query
> mysql_query($query) or die(mysql_error());
> //echo sucess message
> echo("The Post has been deleted...");
>
>
> here is what my problem is...
>
> 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.
$query = "delete From news where id IN($del)";
Take a look at
http://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html. The
user comments are helpful.
Brady
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] deleting muliple feilds from a table using an array
On 24/03/06, benifactor <[EMAIL PROTECTED]> 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
