delete problem

[netman182]

hey i am having a problem with the delete command. i have included the code for help.

 

to me i don't see a problem but obviously there is.

 

it is not deleting the field that the form is sending.

 

it does complete the header fine.

 

some advice would be great.

 

<?php 


include("dbc.php");

$id = $_POST['id'];

$sql="DELETE FROM players WHERE id= '$id' ";
$result=mysql_query($sql);

header("Location: masterrosteredit.php?msg=Your player was deleted");

mysql_close();

?>

[Pikachu2000]

Have you echoed the query string to make sure it contains the value you'd expect it to contain?

[l0gic]

Try using:

$result=mysql_query($sql) or die(mysql_error());