$today=date('Ymd');
$date=date("Ymd",strtotime($today."-3 day"));
$arr=array('baidudy','aamm1');
foreach($arr as $value){
mysql_select_db('$value');
mysql_query("DELETE FROM `clicked` WHERE `date` < '$date'");
mysql_query("DELETE FROM `clickip` WHERE `date` < '$date'");
}
------解决方案--------------------
- PHP code
foreach($arr as $value){ mysql_select_db("$value"); mysql_query("DELETE FROM `clicked` WHERE `date` < '$date'"); mysql_query("DELETE FROM `clickip` WHERE `date` < '$date'"); } echo "循环完了";