Delete image error

[emediastudios]

Can someone see an error here.

I dont get one on screen but it doesnt work.

<?php
if($secret == "56"){
$r = mysql_fetch_array(mysql_query("SELECT * FROM gallery WHERE ID='".$_GET[id]."'"));
unlink($r[photo]);
mysql_query("DELETE FROM gallery WHERE ID='".$_GET[id]."'");
echo "<script>window.location = 'admin.php?p=admin_gallery';</script>";
}
else{
$content .= "You Must Be Logged In To Do That";
}?>

[wildteen88]

Turn error reporting on if you can, by adding the following two lines to the top of your script

ini_set('display_errors', 'On');
error_reporting(E_ALL);

 

If that does work, add some debugging lines into your script:

<?php

ini_set('display_errors', 'On');
error_reporting(E_ALL);

if($secret == "56")
{
echo 'Quering database...<br />';
$r = mysql_fetch_array(mysql_query("SELECT * FROM gallery WHERE ID='".$_GET[id]."'"));

echo '<pre>$r equals ' . print_r($r, true) . '</pre>';

echo 'Deleting '  . $r[photo] . '... ';

unlink($r[photo]) or die('FAILED');

echo ' SUCCESSFUL<br>';
echo 'Deleting from Database...';
mysql_query("DELETE FROM gallery WHERE ID='".$_GET[id]."'") or die('FAILDED. ' . mysql_error());

echo 'SUCCESSFULL';.

//echo "<script>window.location = 'admin.php?p=admin_gallery';</script>";
}
else
{
$content .= "You Must Be Logged In To Do That";
}?>

[hschonen]

try @unlink instead of unlink

did it for me

[jesushax]

shouldnt it be where ID='".$_GET["id"]."'" with speecch marks arounf the id in the get?