connect($dbhost,$dbuser,$dbpw,$dbname,"p"); // $arr_zd=array("remark1"=>"买点","remark2"=>"说明"); $q="select * from ".$table_pre."kh"; $r=$db->query($q); $i=1; while($m=$db->fetch_array($r)){ $str=""; foreach($arr_zd as $k1 => $v1){ if(trim($m[$k1])) $str.=$v1.":".trim($m[$k1])."\r\n"; } if($str){ $str=substr($str,0,-2); $q1="update ".$table_pre."kh set remark='".$str."' where id='".$m["id"]."'"; $db->query($q1); echo $i.".".$str."

"; $i++; } } ?>