php mysql删除失败_php删除mysql数据

不知道那里错了，删除不了，以下是两个页面，请高手赐教，感激不尽！

－－－－－－－－－－－－－－－－－－－－－－－－－－－－

del.php

Deleting an entry from th database&l

不知道那里错了，删除不了，以下是两个页面，请高手赐教，感激不尽！

－－－－－－－－－－－－－－－－－－－－－－－－－－－－

del.php

Deleting an entry from th database

Del an entry

mysql_connect("localhost","root","") or die("Problem connecting to Database");

$query="select*from tbl";

$result=mysql_db_query("example",$query);

if($result)

{

echo "Found these entries in the database:

";

echo "

idx

User Name

Last Name

Free Text

while($r=mysql_fetch_array($result))

{

$idx=$r["idx"];

$user=$r["UserName"];

$last=$r["LastName"];

$text=$r["FreeText"];

echo"

$idx$user$last$text";

} echo "

";

}

else{ echo "No data."; }

mysql_free_result($result);

?>

----------------------------------------------------

dele.php

mysql_connect("localhost","root","") or die ("Problem connecting to DataBase");

$query = "delete from tbl where idx='$idx' and UserName='$UserName' and

LastName='$LastName' and FreeText='$FreeText'";

$result = mysql_db_query("example", $query);

$query="select*from tbl";

$result=mysql_db_query("example", $query);

if($result)

{

echo "Found these entries in th database:

";

echo "

idx

User Name

Last Name

Free Text

while($r=mysql_fetch_array($result))

{

$idx=$r["idx"];

$user=$r["UserName"];

$last=$r["LastName"];

$text=$r["FreeText"];

echo "

$idx$user$last$text";

}

echo"";

}

else { echo "No data."; }

mysql_free_result($result);

?>

展开

全部