Thread: How can I select every date in a given month?
View Single Post
  #3 (permalink)  
Old 18-03-05
OLBG's Avatar
OLBG OLBG is offline
aka Antony
  
Join Date: Mar 2005
Location: Bristol
Posts: 528
Thanks: 0
Thanked 0 Times in 0 Posts
OLBG is an unknown quantity at this point
Are you using php?

Basically you want


SELECT field1,field2 FROM table WHERE datefield>='firstofmonth' AND datefield<='lastofmonth'

firstofmonth and lastofmonth needed to be calculated in php/asp
__________________
Antony
Free Tipster Competition
Affiliate Program on POR - up to £2/lead
Grand National Guide
Reply With Quote