<?php
require_once('zhuayi/include/conn.php');
global $query,$query2;
set_time_limit(0);
$sql="select * from vcms_collect_url3";
$reset=$query->query($sql);
while($row = $query->fetch_array($reset)){
$row['title']=addslashes($row['title']);
$row['count']=addslashes($row['count']);
$sql1 = "insert into vcms_mainfo(id,title,logo) values('','".$row['title']."','article')";
$query->query($sql1);
$articleid = $query->insert_id();
$sql2 = "insert into vcms_article(aid,body,item_id) values($articleid,'".$row['count']."',4)";
$query->query($sql2);
//$sql = "select a.*,b.* from vcms_mainfo a left join vcms_article b on a.id = b.aid where b.item_id = $item_id"
}
?>
<?php
require_once('zhuayi/include/conn.php');
global $query;
$limit = $_REQUEST['act'];
$lh="select a.*,b.* from vcms_mainfo as a left join vcms_article as b on a.id = b.aid where a.logo = 'item' and b.item_id = 1" ;
$result=$query->query($lh);
while($row = $query->fetch_array($result)){
$sql = "update vcms_mainfo set ismake = 1 where id = '".$row['id']."' order by id desc limit $limit";
$query->query($sql);
}
echo "已显示".$limit."条记录";
?>
