各位高手,现在,有个一个每天更新登陆次数的代码,是有60天的,一天1段sql,如下:
$sql="select count(*) as count from ".$user_info[$i]['DB_NAME'].".ACCESS_LOG where TO_DAYS(ACCESS_DATE) = TO_DAYS(now())-5 and APL_NAME='login' and ACTION='LoginDo' and OPERATION='Login'";
$res = $conn->GetRow($sql);
$sql="update cybozu.USER_INFO set LOGIN_COUNT_5 = '".$res['count']."' where USER_LOGIN_ID = '".$user_info[$i]['CUSTOMER_CD']."'";
$conn->Execute($sql);
更新的数据放到LOGIN_COUNT_5字段,因为有60天,所以字段有LOGIN_COUNT_1~60,
如何把上面的代码修改为执行一条,则么去加判断,需要哪些地方做成变量,请指点下,谢谢
$sql="select count(*) as count from ".$user_info[$i]['DB_NAME'].".ACCESS_LOG where TO_DAYS(ACCESS_DATE) = TO_DAYS(now())-5 and APL_NAME='login' and ACTION='LoginDo' and OPERATION='Login'";
$res = $conn->GetRow($sql);
$sql="update cybozu.USER_INFO set LOGIN_COUNT_5 = '".$res['count']."' where USER_LOGIN_ID = '".$user_info[$i]['CUSTOMER_CD']."'";
$conn->Execute($sql);
更新的数据放到LOGIN_COUNT_5字段,因为有60天,所以字段有LOGIN_COUNT_1~60,
如何把上面的代码修改为执行一条,则么去加判断,需要哪些地方做成变量,请指点下,谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货