[PHP-DB] record deletion using checkbox array values
Morning people,
I have a form with checkbox values, if checked an array of id's are passed
to a deletion script.
I can get the array and implode to a string.
Can anyone tell me how to delete all the messages in the DB that have the
checked value.
Presently the script is deleting only the last id value that has been
checked.
---snip-
First the form:
input type=\checkbox\ name=\delete_list[]\ value=\$id\
submit etc
Then the deletion script:
?php
$delete=implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM SENT_ITEMS WHERE ID
= '$delete')))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
?
Been messing about with this one for a while now and I am getting a bit
flustered!
Thx in advance,
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
RE: [PHP-DB] record deletion using checkbox array values
Hi Karl,
$delete = ' . implode( ', ', $delete_list );
$delete = substr( $delete, 0, ( strlen( $delete ) - 3 ) );
then use: DELETE FROM sent_items WHERE id IN ($delete)
Not tested, but should work.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
___
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
-Original Message-
From: Karl Phillipson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 11:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] record deletion using checkbox array values
Morning people,
I have a form with checkbox values, if checked an array of
id's are passed
to a deletion script.
I can get the array and implode to a string.
Can anyone tell me how to delete all the messages in the DB
that have the
checked value.
Presently the script is deleting only the last id value that has been
checked.
---snip-
First the form:
input type=\checkbox\ name=\delete_list[]\ value=\$id\
submit etc
Then the deletion script:
?php
$delete=implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM
SENT_ITEMS WHERE ID
= '$delete')))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
?
Been messing about with this one for a while now and I am
getting a bit
flustered!
Thx in advance,
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] record deletion using checkbox array values
Thanks for all that gave help on this one, problem finally solved! *mops
forehead*
Easy when you know how!
on the form side:
input type=\checkbox\ name=\delete_list[]\ value=\$messid\
script page:
$delete = implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM SENT_ITEMS WHERE MESSAGEID
IN ($delete
{
echo Error deleting message(s);
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
Thx again!
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
-Original Message-
From: Michael Rudel [mailto:[EMAIL PROTECTED]]
Sent: 08 August 2001 10:15
To: 'Karl Phillipson'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] record deletion using checkbox array values
Hi Karl,
$delete = ' . implode( ', ', $delete_list );
$delete = substr( $delete, 0, ( strlen( $delete ) - 3 ) );
then use: DELETE FROM sent_items WHERE id IN ($delete)
Not tested, but should work.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
Besuchen Sie uns am 20. und 21. August 2001 auf der
online-marketing-düsseldorf in Halle 1 Stand E 16
___
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
-Original Message-
From: Karl Phillipson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 11:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] record deletion using checkbox array values
Morning people,
I have a form with checkbox values, if checked an array of
id's are passed
to a deletion script.
I can get the array and implode to a string.
Can anyone tell me how to delete all the messages in the DB
that have the
checked value.
Presently the script is deleting only the last id value that has been
checked.
---snip-
First the form:
input type=\checkbox\ name=\delete_list[]\ value=\$id\
submit etc
Then the deletion script:
?php
$delete=implode(,, $delete_list);
if(!($result = mysql_db_query($DB, DELETE FROM
SENT_ITEMS WHERE ID
= '$delete')))
{
DisplayErrMsg(sprintf(internal error %d:%s\n,
mysql_errno(), mysql_error()));
mysql_close($link);
exit();
}
?
Been messing about with this one for a while now and I am
getting a bit
flustered!
Thx in advance,
Karl
==
Karl Phillipson
PHP SQL Programmer
Saffron Hill Ventures
67 Clerkenwell Road
London
EC1R 5BL
Saffron Hill: 0207 693 8300
Direct Line: 0207 693 8318
