我写的如下,但运行不了,不知那里出错了: $x_u_num=400; //参与随机发贴的人数$x_member=array(); $x_query=$db->query("SELECT uid,username FROM sgwy_members order by rand() limit ".$x_u_num); while($x_mem=$db->fetch_array($x_query)){ $x_member[$x_mem['uid']]=addslashes($x_mem['username']); }$x_thread=array();$x_query=$db->query("SELECT tid,fid FROM sgwy_threads where closed=0 order by rand() limit ".$x_t_num);while($x_thr=$db->fetch_array($x_query)){ $x_thread[$x_thr['tid']]=$x_thr['fid']; } foreach($x_thread as $x_tid=>$x_fid){ $x_uid=array_rand($x_member); $x_user=$x_member[$x_uid];
$db->query("UPDATE sgwy_forums SET author='$x_user' ,authorid=$x_uid WHERE tid='$x_tid' and first=1", 'UNBUFFERED');
$db->query("UPDATE sgwy_threads SET author='$x_user' ,authorid=$x_uid WHERE tid='$x_tid'", 'UNBUFFERED'); }
$x_u_num=400; //参与随机发贴的人数$x_member=array();
$x_query=$db->query("SELECT uid,username FROM sgwy_members order by rand() limit ".$x_u_num);
while($x_mem=$db->fetch_array($x_query)){
$x_member[$x_mem['uid']]=addslashes($x_mem['username']);
}$x_thread=array();$x_query=$db->query("SELECT tid,fid FROM sgwy_threads where closed=0 order by rand() limit ".$x_t_num);while($x_thr=$db->fetch_array($x_query)){
$x_thread[$x_thr['tid']]=$x_thr['fid'];
}
foreach($x_thread as $x_tid=>$x_fid){ $x_uid=array_rand($x_member);
$x_user=$x_member[$x_uid];
$db->query("UPDATE sgwy_forums SET author='$x_user' ,authorid=$x_uid WHERE tid='$x_tid' and first=1", 'UNBUFFERED');
$db->query("UPDATE sgwy_threads SET author='$x_user' ,authorid=$x_uid WHERE tid='$x_tid'", 'UNBUFFERED');
}