mysql sql查询distinct用法以及getdate的用法

Mon, 26 Oct 2009 03:31:37 +0000

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;

    $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;

[评论] mysql sql查询distinct用法以及getdate的用法

Thu, 01 Jan 1970 00:00:00 +0000

向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除

mysql sql查询distinct用法以及getdate的用法

[评论] mysql sql查询distinct用法以及getdate的用法

向东博客专注WEB应用构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除