How do I make my delete query FULLY work?

Question

My delete.php is sending the selected item to the db as dead as it should, but the blog is still staying on the page that its deleted from. What am I doing wrong? this is my query: on the delete.php:

$MyBlog =  $_GET['id'];

$query = "UPDATE `Blogs` SET `status` = 'dead' WHERE `id` = '".$MyBlog."'";

Like I said, this is marking id dead on the db as it should, but not deleting the actual blog off of the page, is this because I don't have: AND `status` != 'dead' on the page it's getting sent from?

Answer 1

how are you selecting the entries on the blog page.

SELECT * FROM blog WHERE status NOT dead

Maybe that would work?

Answer 2

Fine. I'll just post the correct answer then (note the typo in Kieran's):

SELECT * FROM blog WHERE status!='dead'

That's what your SELECT query should look like.