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
>
>