Mysql Delete function not working, given correct URL

Question

I'm trying to make a function in which, when a button is pressed, PHP deletes that record from within the database. The website is being redirected with the correct ID, and the DeleteID Variable has the correct value in it, yet for some reason I can't get it to delete the record

Delete.PHP

<?php
session_start();

//get value of ?id= from the url
$DeleteID = $_GET['id'];

echo $DeleteID;
require("connect.php");

//Linking
$link = connectToDB();

//SQL Query
$sql = "DELETE
          FROM tbl_property
          WHERE propetyid = $DeleteID";

//Execute
$result = $link->query($sql);

//Check
if ($link->affected_rows == 1) {
    echo "Worked";
    echo "<a href='properties.php'> SIGH </a>";
}
else {
    echo "Didn't Work";
    echo "<a href='properties.php'> SIGH </a>";
}
?>

Table

typo. There's typo in `propetyid = $DeleteID"`. Use `propertyid` instead — Aakash Martand, May 27 '17 at 12:19
**STOP!!** Absolutely never use `$_GET` requests for modifications, *especially* not deletions. [It never ends well](http://blog.mischel.com/2008/08/08/hey-you-deleted-my-files/) — Niet the Dark Absol, May 27 '17 at 12:21
You should also be aware that your code is open to SQL injection, and really should be looked into. — gabe3886, May 27 '17 at 12:22
had you been checking for (the real) error, you'd of been thrown something about it. Typo questions are off-topic. — Funk Forty Niner, May 27 '17 at 12:32

score 0 · Accepted Answer · answered May 27 '17 at 12:22

0

There is a spelling mistake in field name you type propetyid instead of propertyid

$sql = "DELETE
          FROM tbl_property
          WHERE propetyid = $DeleteID";

answered May 27 '17 at 12:22

Poorna Rao

335
4
20

Mysql Delete function not working, given correct URL

1 Answers1