56,679
社区成员
发帖
与我相关
我的任务
分享
<?php
$queryA = DB::query("SELECT * FROM A LIMIT 100 ");
while($rowA = DB::fetch($queryA))
{
$id = $rowA['id'];
$wd = $rowA['wd'];
$count = DB::result_first("SELECT COUNT(*) FROM B WHERE `content` LIKE '%$wd%' ");
DB::query("UPDATE A SET `count`='$count' WHERE id='$id' ");
}