[SOLVED] Help needed deleting

[cs1h]

Hi,

 

I have a script that is designed to delete a row from my database, it identifies the row by its unique id. But its not working, can anyone help?

 

The script is,

<?php

include "dog.php";

$id=$_POST['hiddenField'];

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
mysql_select_db("$database") or die(mysql_error()) ;

$sql = ("DELETE FROM items WHERE id = '$id'");
$result = mysql_query($sql);
echo "Deletion success<br /> <a href='arteditor.php'>Click here</a> to return to the admin home.";

?>

 

Any help is appriciated,

 

thanks

Colin

[GingerRobot]

'its not working' is quite vague. What actually happens? Does everything appear to work but the row not get deleted?

 

First off, you dont need the parenthesis around your string defined in $sql. Second, perhaps $id is not defined. Are you sure your field was called hiddenField? (perhaps it was hiddenfield?)

 

Try this to debug:

 

<?php

include "dog.php";

$id=$_POST['hiddenField'];

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
mysql_select_db("$database") or die(mysql_error()) ;

$sql = "DELETE FROM items WHERE id = '$id'";
$result = mysql_query($sql) or die(mysql_error());
echo 'The query was: '.$sql.'<br />';
echo "Deletion success<br /> <a href='arteditor.php'>Click here</a> to return to the admin home.";

?>