php数组应用之比较两个时间的相减排序

答案：$kkk = custom_tuijian("2008-08-15",date("Y-m-d")); 
//echo date("Y-m-d"); 
//print_r($kkk); 

function custom_tuijian($a,$b) 
{ 
$sql = "select `r`.*,`a`.`articlename`,`a`.`author` 
from `phpsir_record1` `r` inner join `jieqi_article_article` `a` 
on `r`.`bookid` = `a`.`articleid` where `r`.`rdate` = '$a' "; 
$res = mysql_query($sql); 
$sql2 = "select `r`.*,`a`.`articlename`,`a`.`author` 
from `phpsir_record1` `r` inner join `jieqi_article_article` `a` 
on `r`.`bookid` = `a`.`articleid` where `r`.`rdate` = '$b' "; 
$res2 = mysql_query($sql2); 
while($row = mysql_fetch_assoc($res)) 
{ 
$row2 = mysql_fetch_assoc($res2); 
$calnum = calnum($row,$row2); 
$a_a[$row['bookid']] = $calnum; 
$x[$row['bookid']] = array($row["articlename"],$row["author"],$row["bookid"]); 
} 
arsort($a_a); 
foreach($a_a as $k=>$v) 
{ 

$kk[] = array($x[$k][0],$x[$k][1],$x[$k][2],$v); 
} 

return $kk; 
} 
function calnum($r1,$r2) 
{ 
// 公式 点击/100+推荐*2+收藏+鲜花*10+月票*10 
return ($r2['clicknum'] - $r1['clicknum']) / 100 + ($r2['shoucangnum'] - $r1['shoucangnum']) 
+ ($r2['xianhuanum'] - $r1['xianhuanum']) * 10 + ($r2['yuepiaonum'] - $r1['yuepiaonum']) * 10 ; 
} 
//数据调用方法
for($ii=0; $ii<100; $ii++){ 
    $bookid=$kkk[$ii][2]; 
    $ml=floor($bookid/1000); 
    echo "<a href=>    }

上一个：php中的数组操作函数整理
下一个：PHP去除数组中重复的元素并按键名排序函数