HELP ME FIND ERROR TO DELETE RECORD
Posted: Wed Oct 01, 2008 9:25 pm
I am unable to delete the record with following Code . WHERE IS ERROR in it ????
<?php
$host="localhost";
$username="username";
$password="mypassword";
$db_name="mydb";
$tbl_name="articles";
$id=$_GET['id'];
$cid = mysql_connect($host,$username,$password);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($task=="del") {
$SQL = " DELETE FROM articles ";
$SQL = $SQL . " WHERE id = $id ";
mysql_db_query($db_name, $SQL, $cid);
}
?>
<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 ("<TD><A HREF=\"manageedit.php?id=$id\">Edit</A></TD>");
echo ("<TD><A HREF=\"delete.php?id=$id&task=del\">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
$host="localhost";
$username="username";
$password="mypassword";
$db_name="mydb";
$tbl_name="articles";
$id=$_GET['id'];
$cid = mysql_connect($host,$username,$password);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
if ($task=="del") {
$SQL = " DELETE FROM articles ";
$SQL = $SQL . " WHERE id = $id ";
mysql_db_query($db_name, $SQL, $cid);
}
?>
<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 ("<TD><A HREF=\"manageedit.php?id=$id\">Edit</A></TD>");
echo ("<TD><A HREF=\"delete.php?id=$id&task=del\">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>