Hi all,

Can I raise a point of principle here.

My databases never have records deleted - instead they are marked as being
deleted in a status field. That way, they are always there for reference.

Unless you are running a system that needs the space or has extremely high
turnover of deleted records, this makes sesne.

Just my 2c.

George in Oxford

> -----Original Message-----
> From: Mathieu Dumoulin [mailto:[EMAIL PROTECTED]
> Sent: 24 February 2003 3:49 pm
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Checkboxes to gather rows to delete
>
>
> It is wrong to use that way of doing it John, cause this will delete ALL
> lines that where printed with a checkbox
> And also, if you are using a old version of PHP with register globals OFF,
> the _POST array will not be available
>
> Mathieu Dumoulin
>
> "1lt John W. Holmes" <[EMAIL PROTECTED]> a écrit dans le message de
> news: [EMAIL PROTECTED]
> > > I have a mysql database with a table using one column as a
> primary key.
> > > (rowID). On a php page I use a query to  list all of the rows of the
> table
> > > and have a checkbox beside each  row that should be used to
> check if you
> > > would like to delete this row. Can someone give me an example
> using post
> > > to pull the boxes that need to be deleted.
> >
> > Easy one.. :)
> >
> > Make sure your checkboxes have the rowID as their value, then you can
> simply
> > do this:
> >
> > $query = "DELETE FROM table WHERE rowID IN (" .
> > implode(',',$_POST['checkboxes']) . ")";
> >
> > and run that query.
> >
> > You'll end up with something that looks like this:
> >
> > DELETE FROM table WHERE rowID IN (1,2,3,4,5)
> >
> > where the numbers will come from only the checkboxes that you selected.
> >
> > ---John Holmes...
> >
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to