Running PHP and SQL commands from a Form Button

[Zan15]

I was wondering how I can run PHP code to delete a mysql entry from a standard button on a php Form. The button code is:

<input type="submit" name="Submit" value="Submit">

so would It be somthing like

<input type="submit" name="<?php code here ?>" value="Submit">

I tried that and it didnt work maybe I'm doing somthing wrong.

Bascily what I'm doing is hacing my script display the contents of a database with a button next to each row saying delete and I want the button to be able to del the row when clicked my full code is:

<?php
mysql_connect();
mysql_select_db( "Songs" );
$query = "SELECT * FROM `titles` ";
$result = mysql_query( $query );
$num_rows = mysql_num_rows( $result );
print "<p align = \"center\">Songs in DataBase: $num_rows <P>";
print "<table border=1 align = \"center\">\n";
while ( $a_row = mysql_fetch_row( $result) ) {

print "\t<td>Name: <a href = \"$a_row[2]\">$a_row[1]<br></td>\n";
print "\t<td>Type: $a_row[3]</td>\n";
print "\t<td>Group: $a_row[4]</td>\n";
print "\t<td><input type=\"Submit\" name=\"Delete\" value=\"Delete\"></td>\n";
print "</tr>\n";
}
print "</table>\n";

$sql = "DELETE FROM 'titles' WHERE 'name' = 'test'";
mysql_query($sql);
mysql_close();
?>

[Claymore]

In order to achieve this, I recommend you read the chapters of the book "Building a database driven website using PHP and MySQL" which are posted on the articles part of the SitePoint Network. There you find the solution to this problem. It is a part of the 4th chapter, which is on publishing MySQL data on the web.
If you would rather skip reading the entire chapter (which I would not recommend), you can find the solution to this problem here.

[Zan15]

Thank You!