detooon 数据库article_data表里的字段数据插入到article表里

 <?php

	//查询data表数据
	$A = array();
	$result = $db->query("SELECT * FROM `cidh_article_data_24`");
	while($r = $db->fetch_array($result)) {
	    $A[] = $r;
	}
	//查询article表数据
	$B = array();
	$results = $db->query("SELECT * FROM `cidh_article_23`");
	while($rr = $db->fetch_array($results)) {
	    $B[] = $rr;
	}

	for($i = 0 ; $i<628; $i++){

		for($b = 0 ; $b<174; $b++){
			//关联两个表
			if($A[$i][itemid] == $B[$b][itemid]){
				//插入数据
				$db->query("UPDATE `cidh_article_23` SET `fromurl`='".$A[$i][qrcode]."' WHERE `itemid`='".$B[$b][itemid]."'");
			}
			
		}

	}

	
?>