[PHP-DB] Checkboxes to gather rows to delete

2003-02-24 Thread Lewis Watson
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

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 Lewis Watson
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 - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:13 AM

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

2003-02-24 Thread Lewis Watson
. } form action= method=POST print input type=checkbox name=\deleteID[]\ value=\$row[teacherID]\; print input type=submit name=\delete_teacher\ value=\Delete the Checked Teachers\; - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED

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

2003-02-24 Thread Lewis Watson
Hi there, I have double checked the column namesIts giving me a Warning: Bad arguments to implode() error Thanks. Lewis - Original Message - From: 1LT John W. Holmes [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 24, 2003 10:36 AM

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

2003-02-24 Thread Lewis Watson
I think the problem is that I need to put the array into a comma delimited group Lewis - 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

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