21,887
社区成员
发帖
与我相关
我的任务
分享
$sqla = "update union_list set list_content='".$newcontent."',lit_title='".$rs[0]["list_title"]."' where id=".$rs[$i]["id"];
//你用单引号把变量框在里面,变量意义就变了!
//改成:
$sqla = "update union_list set list_content=$newcontent,lit_title=$rs[0]["list_title"] where id=$rs[$i]["id"]”;
//或者:
$sqla = "update union_list set list_content=".$newcontent.",lit_title=".$rs[0]["list_title"]." where id=".$rs[$i]["id"];
include_once("inc/init.php");
$sql = "select id,typeid,list_title,list_content,list_from from union_list where list_content like '%/images/%' order by id desc";
$rt = $DB->Query($sql);
$num = $DB->getRowsNum($rt);
$rs = $DB->getRows($rt);
echo $num;die();
for($i=0;$i<$num;$i++)
{
echo $rs[$i][0]."<br/>";
$oldcontent = $rs[$i]["list_content"];
$newcontent = str_replace("/images/","/images-old/",$oldcontent);
//$newcontent = str_replace('"','"',$newcontent);
//$newcontent = str_replace("'","",$newcontent);
$sqla = "update union_list set list_content='".$newcontent."',lit_title='".$rs[0]["list_title"]."' where id=".$rs[$i]["id"];
//echo $sqla;die();
//$DB->Query($sqla);
$connse=mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name,$connse);
mysql_query($sqla);
echo $i."|".$rs[$i]["id"]."<br/>";
mysql_close();
}