PHP Delete Code Error?

S

Sandeep

New member
Hello,
I am trying to make a code for deleting entries from database in MySql with PHP with the following code...

Form Page

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table>
<tr>
<td align="center">Delete DATA</td>
</tr>
<tr>
<td>
<table border="1">
<?php
mysql_connect("localhost","xxxxx","xxxxx") or die("Error: ".mysql_error());
mysql_select_db("webdhaba_try");//add your dbname
$order = "SELECT * FROM try1";
$result = mysql_query($order);
while ($row=mysql_fetch_array($result)){
echo ("<tr><td>$row[FName]</td>");
echo ("<td>$row[LName]</td>");
echo ("<td>$row[Phone]</td>");
echo ("<td>$row[id]</td>");
echo ("<td><a href=\"delete.php?name=$row[FName]\">Delete</a></td></tr>");
}
?>
</table>
</td>
</tr>
</table>
</body>
</html>


Delete FILE

<?
//delete.php
mysql_connect("localhost","xxxxx","xxxxx") or die("Error: ".mysql_error());
mysql_select_db("webdhaba_try");//add your dbname
mysql_query("DELETE FROM try1 WHERE FName='$FName'");
mysql_query($order);
header("location:testdel.php");
?>

Please Help...

Thanks in Advance...
 
Back
Top