Won't delete from database.

[ryeman98]

Hi there, I hope you're having a good day

 

Whenever I click the submit image, that is supposed to delete it, but it doesn't. delete it from the database. Here's the code:

Main page

<?php
<form action=\"http://php.sunnyneo.com/DeleteProject.php\" method=\"post\"><input type=\"hidden\" name=\"id\" value\"".$row['id']."\"><input type=\"image\" src=\"http://php.sunnyneo.com/images/cancel_f2.png\" alt=\"Delete\"></form>
?>

 

Delete page

<?php
$id = $_POST['id'];

$delete = mysql_query("DELETE FROM `projects` WHERE id='$id'")
or die(mysql_error());

header('Location: http://somesite.com/project.php');
?>

[virtuexru]

First off, do just:

 

<?php
$bla = mysql_query("DELETE FROM projects WHERE id = '$id'")
?>

 

But you should probably do this instead for this first page:

 

<?php
<a href="http://php.sunnyneo.com/DeleteProject.php?id=".$row['id']."" /><img src="" border="0" /></a>

//then use the $_GET['id'] method..
?>

[ryeman98]

Still won't delete and I changed a few pages:

 

<?php
require($_ENV['SITE_HTMLROOT']."/include/dbconnect_class.php");
$db = new DB;

$id = $_POST['id'];

$delete = mysql_query("DELETE FROM `projects` WHERE id = '$id'");

header('Location: http://somesite.com/project.php');
?>

[ryeman98]

Bumping this because I am doing this for another site.

[ryeman98]

I'm sorry I have to double bump but I don't know why it isn't working... there aren't any errors or anything.

[trecool999]

Still won't delete and I changed a few pages:

 

$delete = mysql_query("DELETE FROM `projects` WHERE id = '$id'") or die('ERROR: ' . mysql_error());

 

Well there aren't going to be errors unless you request them...

[ryeman98]

I did before but there still isn't any.

[suma237]

Please print  the query and check if is the query is executing or not ?