if ($uids = implode_ids($_POST['user'])) {

//将提交来得的用户id作为数组保存在$uids中，implode_ids是自定义函数，用来处理user

$aids = $a_tatol = 0;

// 定义计数变量

$query = $DB->query(“SELECT u.id,p.pdistribution,p.pwithdraw,w.wwithdraw,w.wyesorno FROM users as u ,profit as p,withdraw as w WHERE u.id=p.uid and p.pid=w.pwid and u.id IN ($uids)”);

//逐一查询10个用户的相关信息

while ($article = $DB->fetch_array($query)) {

//将10个用户的信息作为数组赋值给$article

$pdistribution = $article['pdistribution'] – $article['wwithdraw'];

$pwithdraw     = $article['pwithdraw'] + $article['wwithdraw'];

$xianjin       = $pdistribution – $pwithdraw ;

//信息处理,可以写成自己需要的信息

if ($article['wyesorno'] && $xianjin >= ’0′) {

//条件判断

$a_tatol++;

//计数，该段程序中并未用到，可以去掉，为了省事就直接发上来了

$DB->unbuffered_query(“UPDATE users as u ,profit as p,withdraw as w SET p.pdistribution=’”.$pdistribution.”‘, p.pwithdraw=’”.$pwithdraw.”‘, w.wwithdraw=’0′, w.wwithdate=’0′,w.wreason=’0′,w.wyesorno=’0′ WHERE u.id=p.uid and p.pid=w.pwid and u.id=’”.$article['id'].”‘”);

//根据每个用户不同的id号修改与该用户相关的三个表中数据

}

//end if

}//end while

}

redirect(‘用户信息修改成功’, ‘admin.php’);

//redirect也是自定义函数,用户进行跳转的,可以随便写些东西在上面

} else {

redirect(‘未选择任何用户！’);

}

通过该php语句即可轻松的修改多个mysql表中的数据了，如果还有不明白的可以给我留言。