View Single Post
  #2  
Old 08-22-2006, 02:21 PM
gibson gibson is offline
OSP Starters
 
Join Date: Mar 2006
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gibson is on a distinguished road
Default

Code:

select user
, sum(wins) as wins
from results
where `date` between '2006-08-21' and '2006-08-27'
group
by user
order
by wins


Cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - MySQL Select Date comparisons functions? features?
View Single Post
  #2  
Old 08-22-2006, 02:21 PM
gibson gibson is offline
OSP Starters
 
Join Date: Mar 2006
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gibson is on a distinguished road
Default

Code:

select user
, sum(wins) as wins
from results
where `date` between '2006-08-21' and '2006-08-27'
group
by user
order
by wins


Cheers -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote