mysql style标签替换_mysql update如何替换字段里面的A标签

在添加关键字页面中使用mysql_query("updateyewusettxt=replace(txt,'$GJZ','$GJZ')wheretxtlike'%$GJZ%'");给关键字加上链接，为什么不能反向用mysql_query("updatey...

在添加关键字页面中使用

mysql_query("update yewu set txt = replace(txt,'$GJZ','$GJZ') where txt like '%$GJZ%'");给关键字加上链接，为什么不能反向用

mysql_query("update yewu set txt = replace(txt,'$gjz','$gjz') where txt like '%$gjz%'");

把链接去掉呢。

单独运行也不报错但是运行后内容中关键字链接仍然存在。

贴上删除代码：

$id=$_GET[id];

require("../conn.php");

mysql_query("set names gb2312");

$sql = "select * from guanjianzi where ID='$id'";

$result = mysql_query($sql);

while($row = mysql_fetch_array($result)){

$gjz=$row[1];

$wai=$row[2];

}

$sql=mysql_query("update xinwen set txt = replace(txt,'$gjz','$gjz') where txt like '%$gjz%'");

$sql1=mysql_query("update zixun set txt = replace(txt,'$gjz','$gjz') where txt like '%$gjz%'");

$sql2=mysql_query("update yewu set txt = replace(txt,'$gjz','$gjz') where txt like '%$gjz%'");

$sql3=mysql_query("update chuangxin set txt = replace(txt,'$gjz','$gjz') where txt like '%$gjz%'");

if ($sql and $sql1 and $sql2 and $sql3){

$result=mysql_query("delete from guanjianzi where ID='$id'");

echo "";

}

else

{

echo "";

}

mysql_close()

?>

运行结果提示删除成功，单独运行sql 也不报错。

展开