1
[PHP]<?php
$host="localhost";
$username="user";
$password="rmypwd";
$db_name="mydb";
$tbl_name="articles";
$cmd=$_GET["cmd"];
$id=$_GET['id'];
$cid = mysql_connect($host,$username,$password);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
mysql_select_db('db_name');
if($cmd=='del')
{
// mysql_query("DELETE from $tbl_name WHERE id=$id ");
$sql=("DELETE from $tbl_name WHERE id='$id'");
mysql_query($sql);
print $sql;
echo("User Deleted Successfully&cmd='none'");
exit();
}
?>
<html>
<head>
<title>Edit Lyrics</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<div align="center">
<table width="700" border="0">
<tr>
<td bgcolor="#0099CC"><p> </p>
<p> </p>
<p> </p>
<p> </p></td>
</tr>
<tr>
<td><table width="100%" border="0" align="center">
<tr>
<td width="18%" align="center" valign="top"> </td>
<td width="64%" align="center" valign="top"><p align="left"> <?
$SQL = " SELECT * FROM $tbl_name ";
$retid = mysql_db_query($db_name, $SQL, $cid);
if (!$retid) { echo( mysql_error()); }
else {
echo ("<P><TABLE CELLPADDING=4>\n");
while ($row = mysql_fetch_array($retid)) {
$headline = $row["headline"];
$description = $row["description"];
$id = $row["id"];
echo ("<TR>");
echo ("<TD>$headline</TD>\n");
echo($cmd);
echo ("<TD><A HREF=\"manageedit.php?id=$id\">Edit</A></TD>");
echo ("<TD><A HREF=\"delete.php?id=$id&cmd=del\">Delete</A></TD>");
// echo ("<TD><A HREF=\"delete.php?&cmd=del&id\">Delete</A></TD>");
echo ("</TR>");
}
echo ("</TABLE>");
}
?>
</p>
<p>
</p>
<p> </p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="18%" align="center" valign="top"> </td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#0099CC"> </td>
</tr>
</table>
</div>
</body>
</html>[/PHP]
This is the message I get After executing the command
DELETE from articles WHERE id='69'User Deleted Successfully&cmd='none'
However The record still exists in the database I am using php 4.47 version on server
