[PHP] Delete rows from database

[Balasubramanyam A]

Hi all,

I'm searching names from MySQL and printing it on a browser. Also, I've
provided checkbox for all the rows and a delete button for a page. I want to
delete the selected rows from MySQL when I click on the "Delete" button. How
do I do that?

Here is the code which I used to print the rows after fetching the same from
MySQL

while ($line = mysql_fetch_array($resultset, MYSQL_ASSOC)) {
        echo "\t<tr>\n";
        echo "<td><input type=checkbox name=index /></ td>";
        foreach ($line as $col_value) {
                echo "\t\t<td>&nbsp;$col_value</td>\n";
        }
        //echo "<td><input type=button name=vcancel value=Cancel /></td>";
        echo "\t</tr>\n";
}