读书人

这样写错哪了好像只能清理第一个数据库

发布时间: 2012-06-05 13:54:06 作者: rapoo

这样写哪里错了好像只能清理第一个数据库
$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 "循环完了"; 

读书人网 >PHP

热点推荐