Simple delete statement mysql and php.

See more:

PHP

MySQL

I have a simple MySQL statement that should delete the selected row. I have an update query that works well. It inserts but doesn’t delete.

I am not an expert but the query is simple and easy to read. I do not understand why it is not deleting the data.

Form

$Band_id = (int)$_GET['id'];
$result = mysql_query("SELECT * FROM bands ");

echo "<table border = '1'>
<h4>Edit or Deleat Show:</h4>

<tr>
	<th>Show No</th>
	<th>Band Name</th>
	<th>Venue</th>
	<th>Category</th>
	<th>Stock</th>
	<th>Edit Show</th>
	<th>Delete Show</th>
</tr>";

while($row = mysql_fetch_array($result))
    {
        echo "<td>" .$row['Band_id']. "</td>";
        echo "<td>" .$row['Name']. "</td>";
        echo "<td>" .$row['Venue']. "</td>";
        echo "<td>" .$row['Category']. "</td>";
        echo "<td>" .$row['Stock']. "</td>";
        echo " <input name=\"id\" type=\"hidden\" value=\"". $row["Band_id"] ."\" >";
        echo ("<td><a href=\"editband.php?id=$row[Band_id]\"><button>Edit Details</button></a></td>");
        echo ("<td><a href=\"delete.php?id=$row[Band_id]\"><button>Deleat Show</button></a></td></tr>");
    }
echo "</table>";

delete.php

require 'core/init.php';

$Band_id = (int)$_POST['id'];

$result = mysql_query ("DELETE  FROM bands WHERE Band_id='$Band_id'");

 echo mysql_error();
//header("location:admin.php");

What I have tried:

Refer delete.php