hi i am unable to detete selected record from the link which is created by this code
please help
more del.php
<html>
<head>
<title> Birthday Search Results</title>
</head
<body>
<h1>Birthday search results</h1>
<?
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm=trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo "You have not entered search details. Please try again.";
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
@ $db = mysql_pconnect("localhost", "", "");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("bday");
if (isset($searchterm)) {
$mysql = "DELETE FROM customers WHERE name=$searchterm" ;
if (mysql_query($mysql))
{
echo("<P>The member has been deleted.</P>");
} else {
echo("<P>Error deleting member: " .
mysql_error() . "</P>");
}
}
$result = mysql_query ( "select * from customers where ".$searchtype." like
'%".$searchterm."%' order by name");
while ( $row = mysql_fetch_array($result) ) {
$searchterm = $row["customerid"];
$name = $row["name"];
echo("<P>$name" .
"<A HREF='$_SERVER[PHP_SELF]?searchterm=$customerid'>" .
"Delete this Member</A></P>");
}
die('MySQL error: ' . mysql_error() . '<br>Query: ' . $query);
?>
</body>
</html>
