Originally Posted by bakdong
You haven't given much info. What table in what database? SQL? "delete from database.table;" http://www.t-scripts.com/perl/
Or something completely different? :-)
I'm using MYSQL.
Ok I will explain my design here.
When a user login to the page, he is shown with all the data in an HTML table.
The user is provided with checkboxes where he can select all or certain records to delete. Based on the selected records, the data should be deleted from the actual database when the user clicks the delete button.
I know all the syntax and how to perform deletion of records in MYSQL.
But, the only thing is what should i give in the WHERE part of my SQL statement?
DELETE FROM EMPLOYEE WHERE ID=?;
How can I get this ?
from a HTML table?