$ 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''
On 'R'. 'bookid' = 'A'. 'articleid' where 'R'. 'rdate' = '$ '";
$ Res = mysql_query ($ SQL );
$ Sql2 = "select 'R'. *, 'A'. 'articlename', 'A'. 'author'
From 'phpsir _ record1 ''r'' inner join 'jieqi _ article_article''
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)
{
// Formula click/100 + recommended * 2 + favorites + flowers * 10 + monthly ticket * 10
Return ($ r2 ['clicknum']-$ r1 ['clicknum'])/100 + ($ r2 ['shopnum']-$ r1 ['shopnum'])
+ ($ R2 ['xian1_num']-$ r1 ['xian1_num']) * 10 + ($ r2 ['yuepiaonum']-$ r1 ['yuepiaonum']) * 10;
}
// Data call Method
For ($ ii = 0; $ ii <100; $ ii ++ ){
$ Bookid = $ kkk [$ ii] [2];
$ Ml = floor ($ bookid/1000 );
Echo "<a href = 'HTTP: // www.kanshule.com/files/article/info /". $ ml. "/". $ bookid. ". htm'> ". $ kkk [$ ii] [0]. "</a> ";
}