php删除mysql整行,PHP-MySQL-删除行

I am not too sure what i am doing wrong. i am trying to delete the entire row with this code but it is not working. No error is happening it prints the line that it was deleted but when i go and have a look it is not working. Any thoughts?

$con = mysql_connect("localhost","username","password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("theobse1_scores", $con);

$sql="DELETE FROM times WHERE id='$id'";

if (!mysql_query($sql,$con))

{

die('Error: ' . mysql_error());

}

echo "1 record deleted go back to delete another!";

mysql_close($con)

?>

解决方案

I got it working using this code!

$id =$_REQUEST['id'];

$con = mysql_connect("localhost","username","password");

if (!$con)

{

die('Could not connect: ' . mysql_error());

}

mysql_select_db("database", $con);

// sending query

mysql_query("DELETE FROM times WHERE id = '$id'")

or die(mysql_error());

?>