select distinct(fild1),FScoreCount from Tbl_User order by FScoreCount desc limit 10.
select distinct(fild1),FScore from Tbl_Score where FYear = 2009 and FWeek = '44' order by FScore desc limit 0,10;
Array
(
[seconds] => 55
[minutes] => 41
[hours] => 11
[mday] => 26
[wday] => 1
[mon] => 10
[year] => 2009
[yday] => 298
[weekday] => Monday
[month] => October
[0] => 1256528515
)
select distinct(fild1),FScore from Tbl_Score where FYear = 2009 and FWeek = '44' order by FScore desc limit 0,10;
<?php
$today = getdate ();
print_r($today);
?>
$today = getdate ();
print_r($today);
?>
Array
(
[seconds] => 55
[minutes] => 41
[hours] => 11
[mday] => 26
[wday] => 1
[mon] => 10
[year] => 2009
[yday] => 298
[weekday] => Monday
[month] => October
[0] => 1256528515
)
$currYear = $today ['year'];
select distinct(fild1),FScore from Tbl_Score where FYear = ".$currYear ."and FWeek = '44' order by FScore desc limit 0,10;
select distinct(fild1),FScore from Tbl_Score where FYear = ".$currYear ."and FWeek = '44' order by FScore desc limit 0,10;
作者：jackxiang@向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除
地址：http://jackxiang.com/post/2110/
版权所有。转载时必须以链接形式注明作者和原始出处及本声明！
最后编辑： jackxiang 编辑于2009-10-26 11:34
李开复现身说法成功的十个启发
HTML表单的enctype属性详解评论列表
