Delete a DB entry called by ?open=

npereira

Hi,

I have a script made that will (suppose to ) take the ?open=11
id and delete it from the db.

it is not deleting the id at all, unless I hard code the id in the delete.php file. so:

$open=13; worked but the $open=$_GET["open"]; did not.

Here is the delete.php file:

<html>
<head>
<META http-equiv="refresh" content="2; url=editpage.php">  

</head>
<body>
<?php 
include("db_connect.php");
$result = mysql_query("DELETE FROM page WHERE id = '$open'");
 if($result)
  {echo "<h1>Deleted!</h1><P>One moment please...</P>";}

?>

</body>
</html>

Can anyone help me with this? I'm confused as why it's not working.

LordShryku

use

mysql_query("DELETE FROM page WHERE id = '".$_GET['open']."'")

You need to seperate your superglobals from the string

npereira

thanks