Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-25 Thread Lewis Watson
- Original Message - From: Lewis Watson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 24, 2003 9:35 AM Subject: [PHP-DB] Checkboxes to gather rows to delete 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

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread 1LT John W. Holmes
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

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Mathieu Dumoulin
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

RE: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread George Pitcher
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

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] = 101 [1] = 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I like the way of doing it that Mathieu has shown using the

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread 1LT John W. Holmes
I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] = 101 [1] = 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I like the way of doing it that Mathieu has shown using the

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
Subject: Re: [PHP-DB] Checkboxes to gather rows to delete I appreciate all of the quick replies. I do have globals off. Currently, I have the values for each ID being returned in a array Array ( [0] = 101 [1] = 201 ) where 101 and 201 were the id's of the rows I checked. I have to say I

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread 1LT John W. Holmes
Holmes... - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:13 AM Subject: Re: [PHP-DB] Checkboxes to gather rows to delete I appreciate all of the quick replies. I do have

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:21 AM Subject: Re: [PHP-DB] Checkboxes to gather rows to delete Thats just it. I am just not sure what to do with the array before my delete from query now that I have it :-) Thanks... Lewis You don't have to do anything

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread 1LT John W. Holmes
Thanks. The below code returns each ID in an array like so... Array ( [0] =101 [1] = 201 ). Thanks for the help! Lewis $teacherID = $_POST[teacherID]; $deleteID = $_POST[deleteID]; if(isset($delete_teacher)) { This is where I should loop through checking for the chosen ones to

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
Subject: Re: [PHP-DB] Checkboxes to gather rows to delete Thanks. The below code returns each ID in an array like so... Array ( [0] =101 [1] = 201 ). Thanks for the help! Lewis $teacherID = $_POST[teacherID]; $deleteID = $_POST[deleteID]; if(isset($delete_teacher

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Jason Wong
On Monday 24 February 2003 23:57, George Pitcher wrote: 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

RE: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread John W. Holmes
, 2003 10:36 AM Subject: Re: [PHP-DB] Checkboxes to gather rows to delete Thanks. The below code returns each ID in an array like so... Array ( [0] =101 [1] = 201 ). Thanks for the help! Lewis $teacherID = $_POST[teacherID]; $deleteID = $_POST[deleteID]; if(isset

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
PROTECTED] Sent: Monday, February 24, 2003 10:36 AM Subject: Re: [PHP-DB] Checkboxes to gather rows to delete Thanks. The below code returns each ID in an array like so... Array ( [0] =101 [1] = 201 ). Thanks for the help! Lewis $teacherID = $_POST[teacherID]; $deleteID

Re: [PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread 1LT John W. Holmes
... - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: 'Lewis Watson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 11:09 AM Subject: RE: [PHP-DB] Checkboxes to gather rows to delete Hi there, I have double checked the column namesIts giving me