use the CGI.pm module, checkbox values will come back as an array, so do
something like,
my $q = new CGI;
my @checked_values = $q->param('whatever_row_i_want_to_chuck');
then use the DBI module to chuck it from the SQL table,
use DBI;
my $dbh = DBI->connect("$data_source", $user, $pass);
foreach(@checked_values){
my $sth = $dbh -> prepare("DELETE FROM your_table WHERE id = ?");
$sth->execute($_);
$sth->finish;
}
nothing to it (whatever_row_i_want_to_chuck is the name of your checkbox
group)
--
justin simoni! http://skazat.com
___________________________________________________________________
We NEVER clean the toilet, Neil! That's what being a student is all about!
No way, Harpic! No way, Dot! All that Blue Loo scene is for squares. One
thing's for sure, Neil. When Cliff Richard wrote "Wired for Sound", no way
was he sitting on a clean lavatory! He was living on the limit, just like
me. Where the only place to put bleach is in your hair!
-Rick, from "the Young Ones"
On 7/9/01 12:56 AM, "Daniel Falkenberg" <[EMAIL PROTECTED]>
wrote:
> List,
>
> I have come accross a slightly large hurdle in one of my perl scripts.
> Basically I have a list that prints out some *crud* from a PostgreSQL table.
> Each row has a checkbox located next to it. I want to be able to have the
> user select as many of these check boxes as they desire and then press
> delete 'submit' button and have these selections deleted from the database?
>
> Can some one give me a clue on where to start here?
>
> Regards,
>
> df
>
>
--
Good taste is the enemy of creativity.
-picasso
