1. 
            
             
        
      2. 
    
      

    

      







      
    
      
        
      
            
      網站程序如何讀取一周之內的數據
      
            
            
      2010-12-24
      
            
      一周內的
      sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())<=7"

      昨天
      sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=1"

      今天
      sqlTotal="select Count(*) from Count where DATEDIFF('d',time,Now())=0