PHP - MySQL - Delete Row

mysql

Solution

I got it working using this code!

<?php
$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());      

?>

Problem

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) ?> ```

Original source